Sumif or ifs...

PattiWatson

Hi,

I want to sum a column based on multiple criteria from one column. I have accomplished this in the following way:

=SUMIF({Stage}, "Proposed", {Volume}) + SUMIF({Stage}, "Sold", {Volume})

Is this the best way to do this or is there a cleaner way to accomplish the same thing.

Thanks!

Mike Wilday

That is how I have accomplished it in the past, but more recently, I have been using an or statement mixed with an @cell statement. Like the following example (see screenshot as well) 

=SUMIF(Fruit:Fruit, OR(@cell = "Banana", @cell = "Apple"), Count:Count)

 

PattiWatson

Hi Mike,

That worked really well!  

Thank you!

Patti 

Mike Wilday

You're welcome Patti! Glad I could be of help! Happy SmartSheeting.