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