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?
-
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)))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!