To SUMIF or SUMIFS - Neither are working

I am a newbie and I'm stumped. I am trying to calculate the remaining budget for projects that have a ProjPortStat(us) as "active" in a field on the Sheet Summary (I can successfully calculate a single column where the status is "active").

I've tried 100's of permutations of SUMIF and SUMIFS and each time is either UNPARCEABLE or INVALID OPERATION. The below formula is just the latest in my Summary Sheet Field.

=SUMIFS(ProjPortStat:ProjPortStat, "Active", (Budget:Budget - Spend:Spend))

Screen Shot 2020-07-01 at 11.04.33 AM.png

Find more posts tagged with

Formulas

Accepted answers

Jason Tarpinian

I think you have to break out the SUMIF to make it work:

=SUMIF(ProjPortStat:ProjPortStat, "Active", Budget:Budget) - SUMIF(ProjPortStat:ProjPortStat, "Active", Spend:Spend)

If someone knows how to do it with one SUMIF function, I'd be interested to see how!

All comments

Jason Tarpinian

I think you have to break out the SUMIF to make it work:

=SUMIF(ProjPortStat:ProjPortStat, "Active", Budget:Budget) - SUMIF(ProjPortStat:ProjPortStat, "Active", Spend:Spend)

If someone knows how to do it with one SUMIF function, I'd be interested to see how!

Brian Becnel

Huzzzah!! Thank you! Apparently 101 permutations was needed.

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.