How to add monthly expenses using SumIFS
Hi everyone,
I'm having trouble with a SUMIFS function.
I am attempting to calculate monthly expenses using - so total costs for January, total costs for February, etc.
Here's what I have listed for my January formula:
=SUMIFS([TOTAL PAY]:[TOTAL PAY], [START DATE]:[START DATE], <=DATE(2024, 1, 31), >=DATE(2024, 1, 1))
It's spitting back an 'invalid operation' error.
Any suggestions on how I can resolve this?
Thanks!
Best Answer
-
Hi @Andrew Ryback,
Having a quick look, it appears that you're missing a criterion between the two DATE formula. Try this:
=SUMIFS([TOTAL PAY]:[TOTAL PAY], [START DATE]:[START DATE], <=DATE(2024, 1, 31), [START DATE]:[START DATE], >=DATE(2024, 1, 1))
I bolded the two criterions for better readability. The duplicated criterions are specifying to count the sum when the start dates are in between 01/01/2024 and 31/01/2024.
Cheers,
Ric
Answers
-
Hi @Andrew Ryback,
Having a quick look, it appears that you're missing a criterion between the two DATE formula. Try this:
=SUMIFS([TOTAL PAY]:[TOTAL PAY], [START DATE]:[START DATE], <=DATE(2024, 1, 31), [START DATE]:[START DATE], >=DATE(2024, 1, 1))
I bolded the two criterions for better readability. The duplicated criterions are specifying to count the sum when the start dates are in between 01/01/2024 and 31/01/2024.
Cheers,
Ric
-
Ah! Easy fix. Thanks, Ric - that did the trick.
-
Awesome, you were very close!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 295 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!