Notifications
Clear all
Topic starter
Hi All,
How do I write a SUMIF formula that will only take sum of the multiple of a particular number.
If there are 10 items in a carton, any order that's a multiple of 10 will be a carton order and others will be a loose order.
if it's 30 it's 3 cartons shipped and and if it's 7 then it's loose packing, need to find a sum if for a large data set like this
Posted : 18/01/2023 5:57 am
Something like this?
Posted : 18/01/2023 7:35 am
Topic starter
Thanks a ton, this solved and saved a lot of time for me !!
Posted : 19/01/2023 2:18 am
