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