Sum if by Status, Value & Month..

Hi All,

I have variables of the formula I want in other sheets but cannot get it to work when adding a third criteria. (Unparseable), have tried multiple connotations, reaching out for advice.

Basically I want the sum value for all confirmed projects completing in any given month. bold font below works on it's own returning a value

=SUMIFS(Status:Status, "Confirmed", [$CV Ex GST]:[$CV Ex GST]),[Completion date]:[Completion date] AND(IFERROR(MONTH(@cell), 0) = 3)

cheers.

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hey @Jason P

The SUMIFS function has the syntax =SUMIFS(range to be summed, range1, criteria 1, range 2, criteria2, etc). The formula above does not follow the expected syntax.

=SUMIFS([$CV Ex GST]:[$CV Ex GST], Status:Status, "Confirmed", [Completion date]:[Completion date], IFERROR(MONTH(@cell), 0) = 3)

Will this work for you?

Kelly

Jason P

Morning @Kelly Moore

Thank you, yes this works.

I can see I need to study up on understanding of syntax's and how / what they look for. My =SUMIFS(Status:Status, "Confirmed", [$CV Ex GST]:[$CV Ex GST]) is working and I couldn't understand why adding the month criteria didn't work.. I have some COUNTIFS I'm working on as a side project in another sheet - will have "does not follow the expected syntax" in mind as I work through them.. Thank you again for your help.

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.