SUMIF, not matching text string

I have a row of numbers that I would like to sum only if the header row does not contain a certain text string. I need to use wildcards in the 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)

Posted on Jul 9, 2010 4:30 AM

18 replies

hhk Author

Level 1

8 points

Jul 11, 2010 7:59 PM in response to KOENIG Yvan

Boy, you have got a lot of time on your hands.

Barry

Level 9

60,023 points

Jul 11, 2010 9:55 PM in response to hhk

hhk wrote:
(@ Yvan) Boy, you have got a lot of time on your hands.

And when true, that's a good thing. 🙂

Barry

KOENIG Yvan

Level 8

41,825 points

Jul 12, 2010 1:41 AM in response to hhk

hhk wrote:
Boy, you have got a lot of time on your hands.

Hello

Is someone able to translate this message ?
The old Frenchie doesn't understand what it means.
Not sure if it is a positive or a negative comment .

Yvan KOENIG (VALLAURIS, France) lundi 12 juillet 2010 10:41:00

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

SUMIF, *not* matching text string

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up