Difficulty with sumifs formula
I was hoping someone could help me. Having difficulty getting my sumifs formula to work.
I am trying to sum a total if a project is closed and for projects closed within the year 2020. Currently this is the formula I am trying to use (tried different variations to no success):
=SUMIFS({Cyndy Brewczak Project List Range 1}, "Closed", {Cyndy Brewczak Project List Range 2}, AND(@cell >= DATE(2020, 1, 1), @cell <= DATE(2020, 12, 31), {Cyndy Brewczak Project List Range 4})))
Project list 4 in the example above is the column that has the totals that need to be summed.
If anyone can provide some insight or helpful hints it'll be greatly appreciated.
Thanks!
Best Answer
-
For SUMIFS, the range to sum should come first. Then enter your range/criteria sets.
Answers
-
For SUMIFS, the range to sum should come first. Then enter your range/criteria sets.
-
Paul - thank you greatly. Not sure why I didn't try that, makes too much sense I suppose : )
Merry Christmas and happy holidays to you and your family sir!
-
Happy to help, and same to you and yours. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!