Sumif or ifs...
Options
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!
Tags:
Comments
-
Hi Mike,
That worked really well!
Thank you!
Patti
-
You're welcome Patti! Glad I could be of help! Happy SmartSheeting.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!