Thread: SUMIF
View Single Post
  #1   Report Post  
Joseph
 
Posts: n/a
Default 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