SUMIF
 

I want to use SUMIF the first four letters of the row are "Pear" without
concern as to what the ending is. I can't seem to get the Left(range,4) to
work with SUMIF.

Any ideas?

Apple 6
Pear 5
Pears 4
Pearx 3
Pear 2

Thanks.
Joe

Do a google search on your name and you'll find that Jason Morin answered
your question,
here's his answer

=SUMIF(1:1,"Pear*",2:2)


--

Regards,

Peo Sjoblom


"Joseph" wrote in message
...
I want to use SUMIF the first four letters of the row are "Pear" without
concern as to what the ending is. I can't seem to get the Left(range,4)
to
work with SUMIF.

Any ideas?

Apple 6
Pear 5
Pears 4
Pearx 3
Pear 2

Thanks.
Joe

Try the following...

=SUMIF(A1:A5,"Pear*",B1:B5)

OR

=SUMIF(A1:A5,C1&"*",B1:B5)

....where C1 contains your criterion.

Hope this helps!

In article ,
"Joseph" wrote:

I want to use SUMIF the first four letters of the row are "Pear" without
concern as to what the ending is. I can't seem to get the Left(range,4) to
work with SUMIF.

Any ideas?

Apple 6
Pear 5
Pears 4
Pearx 3
Pear 2

Thanks.
Joe