Checking a Date Range

PeterSilano

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.

Paul Newcome

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?

PeterSilano

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.

Paul Newcome

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)))