How to Use SUMIF Function for Sheet Summary

Hello! I am trying to use smartsheet to support budget tracking. I'd like to summarize the amount spent and section by our spend category. So if my Cost Center Category is equal to "Paid Media" I would like a sum of all rows meeting this criteria.

So my range headings are Cost Center Category and Amount, my Criterion is that Cost Center Category="Paid Media"

Thanks all in advance for your help-- I've tried copying and pasting some other's formulas and have not been successful.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!