Sumifs multiple criteria single column help

stesmit

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"))

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

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!