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

  • Paul Newcome
    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?

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

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

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!