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