Chas17 said:=SUMPRODUCT((C4:C12=1)*(D4:D12="AOV")*(E4:E12>""))
If colmn C contained more than just a 1, e.g. 1JCHBUV255, how could the above formula be adjusted to use only the first char in colm c?...
ADVERTISEMENT
Chas17 said:...
Incidently, in the formula
=SUMPRODUCT(--(LEFT(C4:C12)="1"),--(D4:D12="AOV"),--(E4:E12>""))
what do the -- mean?
how does it differ from
=SUMPRODUCT((C4:C12=1)*(D4:D12="AOV")*(E4:E12>""))
Chas17 said:Just_Jon,
No, Thanks. Formula worked and I learned more having to manipulate it.
Hands on stuff. Thanks.
Chas