countif or sumproduct with 2 part formula.

Originally Posted by FDibbins

Indicate which entries you want counted please?
guessing...
=SUMPRODUCT((((E2:E800-C2:C800)>0.084)*1)-(e2:e800<d2:d800))

Column E Late Unload only in red. My conditional formatting elimates the red if the truck was late and is yellow. Box I4 should say 2 right now with the two red late unloads. When column d is yellow the time in column e no longer matters

For the record I truly appreciate the help. the problem with the equations are that an early truck, or more late trucks than unloads kicks it out. I almost need it to be count e2:e800-c2:c800>.084 only if d2:d800<c2:c800 or dont count if greater