How to total spend by month?
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
-
Hello @AmandaBM,
Something like this perhaps?
=SUMIFS([Actual Spend]:[Actual Spend], [Expense Month]:[Expense Month], [Expense Month]@row)
https://www.linkedin.com/in/zchrispalmer/
Answers
-
Hello @AmandaBM,
Something like this perhaps?
=SUMIFS([Actual Spend]:[Actual Spend], [Expense Month]:[Expense Month], [Expense Month]@row)
https://www.linkedin.com/in/zchrispalmer/
-
That worked! Thanks, Mr. Chris. Another question, how would I be able to either pull that into another sheet? What would the formula look like?
-
Glad this worked for you!
To pull this into another sheet you'll need to enter the formula on your primary sheet, then click the "Reference Another Sheet" to find the ranges for your formula:
https://www.linkedin.com/in/zchrispalmer/
-
Is it possible for us to chat about this if you have time this week?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!