J
jhorsley
All,
I'm trying to do a sumif. For the criteria I want to sum anything that
begins with a value in cell A7. So my formula looks like
=sumif('Worksheet2,!$I$3:$I$586,A7*,'Worksheet2,!J7:J590)
the value in cell A7 is 4040 SL
I've tried all sorts of variations for the A7* but it returns 0. If I
type in "4040 SL*" for the criteria it comes up with a pretty close
number but not the exact number.
Any ideas?
Jhorsley
I'm trying to do a sumif. For the criteria I want to sum anything that
begins with a value in cell A7. So my formula looks like
=sumif('Worksheet2,!$I$3:$I$586,A7*,'Worksheet2,!J7:J590)
the value in cell A7 is 4040 SL
I've tried all sorts of variations for the A7* but it returns 0. If I
type in "4040 SL*" for the criteria it comes up with a pretty close
number but not the exact number.
Any ideas?
Jhorsley