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

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

HTH
Jason
Atlanta, GA

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


.