Just_Jon,
Your formulas works, I changed it to
=SUMPRODUCT(--(LEFT(C4:C12)="1"),--(D4:D12="AOV"),--(E4:E12>""))
colm C is what I needed.
Aladin,
Colm C contains str's such as
1JCHBUV255
1JSIAV44
2JCHBUV531
3JSIBUV668
The first char is the UNIT, search for Unit 1, needed to look for all in col c that first char was a 1.
the conditional (E4:E12>"") was looking for if a string had been entered in those cells or if it was still blank. colm E would have a User name entered if that work was complete. The Search was for Unit 1 AOV type valves where work was indicated completed by user name entry.
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>""))
Thanks,
Chas