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

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.