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
-
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
Answers
-
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
-
Thank you Joseph! That fixed it perfectly.
Help Article Resources
Categories
Check out the Formula Handbook template!