Sumif or ifs...

PattiWatson
PattiWatson ✭✭
edited 12/09/19 in Formulas and Functions

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!

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!