Sumif formula problem

Hi, I'm trying to modify this formula:

=SUMIFS({Total Sq Ft Scanned}, {Field Status}, "Completed", {Field Work Completed Date}, AND(IFERROR(MONTH(@cell), 0) = 7, IFERROR(YEAR(@cell), 0) = 2021))

The Field Status column is a drop-down. I want it to sum up every status EXCEPT completed (other stutuses are In progress, Scheduled, and on-hold), but I'm not sure how to re-write to do that?

Find more posts tagged with

Accepted answers

All comments

Brett Wyrick

Hey Kelly - you can rewrite it like this (as long as your existing formula is working):

=SUMIFS({Total Sq Ft Scanned}, {Field Status}, <>="Completed", {Field Work Completed Date}, AND(IFERROR(MONTH(@cell), 0) = 7, IFERROR(YEAR(@cell), 0) = 2021))

Basically, the "<>=" means "is not equal to".

Let me know if this solution works for you, and if it does, please mark it as such! Have a great day.

Kelly Ospina

Hi Brett, thank you! I just tried it, and I'm getting an error message. I realized I needed to change the date column to the date received (not date completed), which I did. However, it's still fighting me. I think it may be because some of the status fields are just blank.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.