Mike, here is the actual formula with the last part of the formula
that you provided to me, and it does indeed work for the completes! I
just want to add 3 more pieces of equipment to the first part where
"BY-PASS CAPSULE" is now.

=SUMPRODUCT(--(JobLogEntry!L2:L33331=B7),--(JobLogEntry!
L2:L33331<=B9),--(JobLogEntry!D2:D33331="BY-PASS CAPSULE")*(LEFT
(JobLogEntry!P2:P33331,8)="COMPLETE"))