countif or sumproduct with 2 part formula.

Originally Posted by JohnTopley

Try

=SUMPRODUCT((D2:D500<C2:C500)*(E2:E500-C2:C500>0.084))

result is 2!

HOLY **//#%$&@%&#%@ Thank you.. Let me double check this is gonna work, I had it working yesterday until I got into early trucks. If this works I owe you a beer, and I will mark solved but heres some rep now!!!