SUMPRODUCT to ignore text

[plotting]

Looked through other posts about this and cannot make isnumber work with sumproduct

=SUMPRODUCT(--(A:A>B:B))

[TABLE="width: 500"]
<tbody>[TR]
[TD]User 1[/TD]
[TD]User 2[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]

I'd expect to get 3 as the answer but since it's counting the text it gives me 4, any help would be greatly appreciated

 

[shift-del]

Plotting,

simply:

[COLOR=#333333]=SUMPRODUCT(--(A2:A4>B2:B4))[/COLOR]

 

[plotting]

Eh I guess I should have explained more, sometimes in cells A593 and B593 for example there will be text that's why I think I need ISNUMBER

 

[AhoyNC]

Maybe:

[TABLE="width: 582"]
<colgroup><col width="582"></colgroup><tbody>[TR]
   [TD="width: 582"]=SUMPRODUCT(--(A:A>B:B),--(ISNUMBER(A:A)),--(ISNUMBER(B:B)))[/TD]
 [/TR]
</tbody>[/TABLE]

 

[plotting]

This worked perfectly and I figured out my error so double thanks!

Maybe:

[TABLE="width: 582"]
<tbody>[TR]
[TD="width: 582"]=SUMPRODUCT(--(A:A>B:B),--(ISNUMBER(A:A)),--(ISNUMBER(B:B)))[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

You're welcome. Thanks for the feedback.

 

[Peter_SSs]

Whilst the formula works & is shorter to write, I'd highly recommend shortening the range. For example =SUMPRODUCT(--(A1:A1000>B1:B1000),--(ISNUMBER(A1:A1000)),--(ISNUMBER(B1:B1000)))
calculates nearly 100 times faster on my machine (because it doesn't have to process all 1,000,000+ rows, most of which are likely empty)