SUMIFS formulas that include date ranges as criteria
Options
Hi!
I would like to sum Claire's projected hours for September. I don't know how to include dates in my SUMIFS formula. Essentially we'll want to sum any projected hours that fall between 09/01/20 and 9/30/20 in End Date and Start Date.
Thanks in advance for your help!
Answers
-
Try this...
=SUMIFS([Projected Hours]:[Projected Hours], Who:Who, "Claire Robertson-Kraft", [Start Date]:[Start Date], @cell <= DATE(2020, 09, 30), [End Date]:[End Date], @cell >= DATE(2020, 09, 01))
-
This is perfect. Thanks so much, Paul!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!