Checking a Date Range
Hello,
I am trying to have a formula do a Sumif on a set amount of data. The range would be the dates within in the data, the criteria would be two set dates. And then the sum would simply be the amount between those two set dates. Is there a way for the sumif/sumifs formula to get me the sum by referencing the two dates and checking to see if any dates match in between them basically. Any help on this would be greatly appreciated.
Answers
-
It is very possible. Are you able to provide a screenshot for reference? Are you wanting the two dates to be flexible, or would they be something like the first and last day of a specific month, or something else?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul, I will provide you with a screenshot of the dashboard I am working off of. Basically in column 4 for the row 270 park, the formula would have to check the sums of what happened at that project between the dates 11/5 & 11/12. My idea is that it will need a SUMIFS since it will have to check multiple dates the 11/5 & 11/12 and then find any information between those dates and provide the sum. Hope this lets you understand what I am trying to achieve more.
-
Try something like this (assuming the ranges to be evaluated are on another sheet)...
=SUMIFS({Column To Be Summed}, {Date Column}, AND(@cell >= DATE(2021, 11, 05), @cell <= DATE(2021, 11, 12)))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!