Help with a SUMIF / TODAY Formula

Hi! I am trying to write a SUMIF formula that calculates four separate column values that is less than 7 days old.

The below formula works, but I need to figure out how to add in the 3 other columns I need to include in the calculation. Column names: Motion Temp Total, Still Perm Total, Still Temp Total

Any help would be greatly appreciated. :)

=SUMIFS([Motion Permanent Total]:[Motion Permanent Total], [Date Completed]:[Date Completed], <TODAY(7))

Find more posts tagged with

Accepted answers

All comments

KPH

Hi @Olivia Doiron

I would simply do three SUMIFS and add the results together.

=SUMIFS([Motion Permanent Total]:[Motion Permanent Total], [Date Completed]:[Date Completed], <TODAY(7))

SUMIFS([Still Perm Total]:[Still Perm Total], [Date Completed]:[Date Completed], <TODAY(7))

SUMIFS([Still Temp Total]:[Still Temp Total], [Date Completed]:[Date Completed], <TODAY(7))

Olivia Doiron

Thank you! That is what I did! I was hoping to condense to one formula…although now thinking about it, it is probably better this way. :)

Paul Newcome

It is not possible to have different range sizes within the same function, so the only way is to add the three SUMIFS together. Fortunately you can keep this all in a single formula so that you only need a single column for it instead fo having to enter each SUMIFS into separate columns.

KPH

Good to hear @Olivia Doiron

I just want to be sure that you aren't creating three cells with one SUMIF formula in each. Three SUMIFS with the plus sign between them is still one formula.

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.