SUMIFS Formula to calculate the sum between dates

Hey Smartsheet Community,

I have a rather simple formula that is giving me trouble, I am just trying to get the sum of a revenue column between two dates.

So far this is what I have and it is coming back unparseable:

=SUMIFS({start date}, >[Start Date]@row AND({end date} < [End Date]@row), {revenue})

Any help here would be great!!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!