SUMIFS

Hi,

I'm looking to sum the cells in a column if another corresponding column is either of two values. I'm getting #UNPARSEABLE though! 😕

=SUMIFS({Data Range Spend}, {Data Range Award Type}, OR(@cell = "Direct Award”, @cell = "Mini-Competition”))

Any thoughts welcome!

Thanks,

Derek

Find more posts tagged with

Formulas

Accepted answers

Heather Duff

Hi @Del Horne ,

This looks like you'll just need a SUMIF. Here's what you'll use:

=SUMIFS({Data Range Award Type}, OR(@cell = "Direct Award”, @cell = "Mini-Competition”),{Data Range Spend})

Note that I moved the range you want to sum to the end, because (for some strange reason) the summed data is at the end in a SUMIF instead of the beginning, as in SUMIFS.

Hope this helps!

Best,

Heather

All comments

Heather Duff

Hi @Del Horne ,

This looks like you'll just need a SUMIF. Here's what you'll use:

=SUMIFS({Data Range Award Type}, OR(@cell = "Direct Award”, @cell = "Mini-Competition”),{Data Range Spend})

Note that I moved the range you want to sum to the end, because (for some strange reason) the summed data is at the end in a SUMIF instead of the beginning, as in SUMIFS.

Hope this helps!

Best,

Heather

Del Horne

Thanks @Heather D – also turns out the issue was I had pasted in the formula from TextEdit and the smart quotes came over too. Must remember to convert to plain text! 🤣

MoJones

Hello. Hope everyone is well. I'm having issues with a =SUMIF OR =SUMIFS formula

=SUMIFS({Fed Admin FTE Usage}, >0, {Employment Status}, "On-Board")

I'm getting invalid operation. Please help.

Heather Duff

Hi @MoJones ,

You are missing one component - the range you want to sum.

=SUMIFS({name of range you want to sum}, {Fed Admin FTE Usage}, >0, {Employment Status}, "On-Board")

That should do the trick - just replace the bolded part with the actual name of the range. If you're wanting the FTE Usage range, you can put that in there.

Hope this helps - let me know if it works!

Best,

Heather

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.