SUMIFS Formula to calculate the sum between dates

John- Michael Diedrich

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!!

Joseph Gentile

Hi @John- Michael Diedrich,

Try put the "Revenue" reference in the first argument for the range and add the @cell function into your formula. Example below.

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

I started a test sheet. Here's a link. https://app.smartsheet.com/b/publish?EQBCT=529dded29d1a4e44870469fbecd6ac77

Fake Data for the reference sheet - https://app.smartsheet.com/b/publish?EQBCT=27e97e94ada84cfbbf8394f98f4ade41

Joseph Gentile

Hi @John- Michael Diedrich,

Try put the "Revenue" reference in the first argument for the range and add the @cell function into your formula. Example below.

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

I started a test sheet. Here's a link. https://app.smartsheet.com/b/publish?EQBCT=529dded29d1a4e44870469fbecd6ac77

Fake Data for the reference sheet - https://app.smartsheet.com/b/publish?EQBCT=27e97e94ada84cfbbf8394f98f4ade41

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/297925#Comment_297925

Thank you Joseph! That fixed it perfectly.