SUMIF

[Joseph]

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

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA