Trouble with sumproduct formula counting blanks as 1

Hello!

Basically, I am trying to highlight cells in a large database that match newly entered data (to help select similar previous cases).

Please see screenshots here: http://imgur.com/a/JMSz5

I'm having trouble with one of my formulas (not sure if this is the fault of the conditional formatting highlighting formula or the total column or both) counting blank cells as 1.

You can see that even blank cells are being counted as highlighted matches & the total column as 18 (should be 0).

The conditional formatting applied to the range E5:V11 (scores) is =ABS(E$2-E5)<=$W$2

The formula in W5 to count the number of targets met is =SUMPRODUCT(--(ABS(E5:V5-$E$2:$V$2)<=$W$2)), then copied down.

Ideas on how to remedy? Any help/suggestions would be greatly appreciated!
Cheers!!!

You can add a criteria to no include blanks..

=SUMPRODUCT(--(ABS(E5:V5-$E$2:$V$2)<=$W$2),--(E5:V5<>""))

This worked great! Thank you so much!

The conditional formatting (=ABS(E$2-E5)<=$W$2) is still highlighting blank cells.

I tried: =ABS((E$2-E5)<=$W$2),--(E5:V5<>"")) but am getting an error. Any ideas?

For the CF Use the AND function

=AND(ABS(E$2-E5)<=$W$2,E5<>"")

Yay! Thank you sooo much!!!

You're welcome.