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)