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
Check out the Formula Handbook template!