SUMPRODUCT Step By Step - Part 1

[Simon Lloyd]

Simon,

In the examples shown so far, the coercion was/is needed on the conditional test. As such, it is not material whether the test is for text or for numbers. SO if A2:A20 contained numbers, and we wanted to count those > 10, we would still use some coercion operator, such as

=SUMPRODUCT(--(A2:A2>10))

Is that what you were asking?

In a way yes (although i pretty much new the answer before i posted), however i was more interested as to whether the coercion was affected by the numbers that were already -1, 1 and 0.

Like:
=SUMPRODUCT(--(A2:A2=-1))