SUMIF, *not* matching text string
I tried the following:
=SUMIF($F$1:$BK$1," SHIP",F2:BK2)
Didn't work. I tried the inside and outside the quotes. Neither worked. Is there a way to do this?
MacBook Pro, Mac OS X (10.6.4)
Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
MacBook Pro, Mac OS X (10.6.4)
hhk wrote:
Thanks for that. I see what's going on now. In both my original post and my follow up, my greater than and less than symbols disappeared from the formula I posted. Gotta admit that had me scratching my head.
I tried your suggestion and it simply did not work for me. I worked around it by summing the range and subtracting the result of a SUMIF formula that matches the text string.
Badunit wrote:
Did you have the less than and greater than symbols inside the quotes or outside?
Barry wrote:
BTW (to Yvan), after posting the picture, I added an "=B$1=" ship" comparison in row 6 to round out the set, and got a "FALSE" result in each column. That's consistent with the rest of the results shown, but not with the results from the SUMIF function using " ship" as the condition argument. Bug, or within the expected behavior? I've sent you the test file, should you want to take a look.
Hi Barry.
I received nothing from you.
hhk wrote:
Sorry, I mis-typed the formula in my original post. I'm trying to test that a certain text string is not contained in the range. What I tried was:
=SUMIF($F$1:$BK$1,"SHIP",F2:BK2)
I did refer the the User Guide before I posted and there is no mention of a not-equals operator.
SUMIF, *not* matching text string