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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!