Looking for help with a SUMIFS statement
Good morning!
Looking for some help with the below SUMIFS statement. I'm getting a couple different errors returned depending on my mood. The challenge is the final criteron where I want to check a cell and return true if the cell date is within a certain range.
=SUMIFS([AC Size]:[AC Size], State:State, "MA", [PTO Forecast (UCC +30)]:[PTO Forecast (UCC +30)], true, [Utility Construction Completion +30]:[Utility Construction Completion +30], (AND(>=DATE(2019, 1, 1), <=DATE(2019, 1, 31))))
Comments
-
You have a few extra parenthesis, and you will need to use the @cell reference. Try something like this...
=SUMIFS(.............................ility Construction Completion +30], AND(@cell >=DATE(2019, 1, 1), @cell <=DATE(2019, 1, 31)))
Another option if you are trying to look at a particular month and you don't want to have to worry about adjusting how many days are in that month, you could use
AND(MONTH(@cell) = 1, YEAR(@cell) = 2019))
You could also use different cells (dropdowns even) for the month and year and reference those. That way you don't have to edit the formula and worry about accidentally breaking something.
AND(MONTH(@cell) = [Month Helper Column]@row, YEAR(@cell) = [Year Helper Column]@row))
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives