How to total spend by month?

AmandaBM ✭✭
edited 01/08/24 in Formulas and Functions

I am new to smart sheet attempting to create a budget tracker and will need to total the spend by month, for now just using actual spend. I tried a formula I saw online and keep receiving unparseable, could be user error though. Attaching a screenshot of the headers I am using and some fake data for testing. I may either pull this to another sheet, also open to recommendations on best way to do this. Thanks!

Formula: =SUMIFS([Expense Month]:[Expense Month], [Month #]@row, [Actual Spend]:[Actual Spend])


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!