SUMPRODUCT with multiple criteria
Biff and Pete,
Thanks guys for helping me....I have tried both ways, but I can't
get either way to work....I can't see what the problem is here that
stops it from working. Biff's example:
=SUMPRODUCT(--(ISNUMBER(MATCH(JobLogEntry!D2:D33331,A22:A25,0))) ,--
(JobLogEntry!L2:L33331=B7),--(JobLogEntry!L2:*L33331<=B9),--(LEFT
(JobLogEntry!P2:P33331,8)=A25))
Pete I tried your formula it wouldn't work with more than piece of
equipment.
?????Puzzled!!
Ken
|