Looked through other posts about this and cannot make isnumber work with sumproduct
=SUMPRODUCT(--(A:A>B:B))
<tbody>
</tbody>
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
=SUMPRODUCT(--(A:A>B:B))
User 1 | User 2 |
10 | 5 |
15 | 7 |
20 | 9 |
<tbody>
</tbody>
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