Checking a Date Range

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!