SumProduct Query for a differential of more than two

I am currently using the following formula

PHP Code: 

=SUMPRODUCT(--(H9:H17=(F9:F17+2))*(H9:H17<>""))+SUMPRODUCT(--(H9:H17=(F9:F17+3))*(H9:H17<>""))+SUMPRODUCT(--(H9:H17=(F9:F17+4))*(H9:H17<>""))+SUMPRODUCT(--(H9:H17=(F9:F17+5))*(H9:H17<>"")) 


It works but is messy.

I was hoping for something like SUMPRODUCT(--(H9:H17=(F9:F17+=<2))*(H9:H17<>"")) but this is rejected by excel as not valid.

Is there a simpler way of counting the number of times cell H9 to H17 exceeds it conterpart in column F by more than 2?

I can provide a worksheet if possible.

I have googled and used Bingchat but not found the round solution.

Sample attached.

The answer should be three.

Originally Posted by AliGW

You are allowed to ask here first - we don't have to be your last resort.

Your signature line sums up my thoughts. I alway think it better to try and find and answer and work out why it is correct. I remember things better that way, rather than just being told that this is the way.

Thank you - It's absolutely spot on. I knew I wasn't far out, but I wouldn't have thought have putting the < where it does go.