When I'm using a SUMIFS formula, I need to reference a specific month from a wider range of dates.
How do I do this?
Best Answer
-
Your formula seems a little bit bugged.
According to what you say this one would work for September:
=SUMIFS({Recycle Range}, {Date Range}, MONTH(@cell)=9)
This will add the recycle tonnage for September.
Hope it helped!
Answers
-
Can you be more specific? Maybe include a screenshot or what you've gotten to with your formula so far?
If you're looking to extract a Month out of a date field, you can use the MONTH() function and it will return a number (1-12) representing the month in the date field.
-
Thanks for offering a solution David.
What I'm looking for is a means to extract a dataset from a database that relates to a specific month. In my requirement this is recycling tonnage for September as an example. We capture the dates of site decommissions and the amount of waste that is recycled for each date. The dates are held in one column in MM/DD/YYYY format and the recycling tonnage for each date is held in another column in simple number format.
My thought is that the SUMIFS could add the values of the recycling tonnage, I could use the formula of:
=SUMIFS({Recycle range}, {Date range}, {Date Range}, >DATE(2020, 9, 1), {Date Range}, <=DATE(2020, 9, 30))
Needless to say, that doesn't work!
Any help gratefully received. 🙏
-
Your formula seems a little bit bugged.
According to what you say this one would work for September:
=SUMIFS({Recycle Range}, {Date Range}, MONTH(@cell)=9)
This will add the recycle tonnage for September.
Hope it helped!
-
Thanks to the two David's for their help here. The David Joyeuse solution works (and on reflection seems so simple!)
Many thanks to both of you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!