SUMIFS formula between two dates in a date column

Natye Briggs
Natye Briggs ✭✭
edited 07/06/23 in Formulas and Functions

I am new to the Smartsheet world and this maybe an easy formula for most of you. I need something that can sum data from one column (Class Total Hours) between a date range from a date column (Date of Participation). I attempted twice with two separate formulas and it provides me with 22.5 instead of 52.5 for the month of February. What am I doing wrong?

=SUMIFS([Class Total Hours]:[Class Total Hours], [Date of Participation]:[Date of Participation], >=DATE(2023, 2, 1), [Date of Participation]:[Date of Participation], <DATE(2023, 2, 28))

=SUMIFS([Class Total Hours]:[Class Total Hours], [Date of Participation]:[Date of Participation], AND(@cell >= DATE(2023, 2, 1), @cell < DATE(2023, 2, 28)))

In addition, how can I make this formula extract future dates? For Instance prepare the same formula to pull August data once it is entered.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!