Sumif or ifs...

PattiWatson · 07/09/19

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 · 07/09/19

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 · 07/10/19

Hi Mike,

That worked really well!

Thank you!

Patti

Mike Wilday · 07/10/19

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

Sumif or ifs...

Comments

Help Article Resources

Categories