Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

8 points

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

59,861 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,807 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

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 ID.

Learn more Sign up