SUM "Duration" based on date Range

I have a sheet with an "End Date" and "Duration" columns. I need a formula that will look at the "End Date" and see if it is equal to or between two dates and then SUM the duration. Ex. Date range 6/8/2020 through 6/14/2020 and I want to SUM the total duration. Thank you in advance.


Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!