Sumifs multiple criteria single column help

Hello,
I'm having trouble creating a formula that will sum if multiple criteria in a single column are met. I want to sum LOE column when the capability = one of 4 values. I'm using the SUMIFS and OR functions to try to make this work in a sheet summary metric but getting the #UNPARSEABLE error. Found a few other posts on this topic but I wasn't able to make this work. Thanks for any suggestions!

=SUMIFS([LOE]:[LOE], [Capability]:[Capability], OR(@cell = "Availability", @cell = "Order", @Cell = "Fulfillment", @cell = "Foundation"))

Find more posts tagged with

Formulas

Accepted answers

DKazatsky2

Hi @stesmit,

You are getting the error because your 3rd item in the "OR" has @Cell, note that it is capitalized. If you change that to @cell you should be all set.

Hope this helps,

Dave

All comments

DKazatsky2

Hi @stesmit,

You are getting the error because your 3rd item in the "OR" has @Cell, note that it is capitalized. If you change that to @cell you should be all set.

Hope this helps,

Dave

stesmit

Thanks Dave! That got me out of the error message, but the results returned are "0". I've got data in both of those columns to match but also some blanks for the LOE column. Any other suggestions?

DKazatsky2

@stesmit,

Well, now you have me stumped. I have recreated and am getting results.

stesmit

@DKazatsky2,
I figured out the issue… LOE is a formula that reads a 'size' column entry and gives it a numeric value. I used the Value() function to cast the output as a number, and got the results I needed. Thanks 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.