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

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
Answers

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

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?

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

@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!
Help Article Resources
Categories
Check out the Formula Handbook template!