"Ragdyer" wrote in message
...

The *asterisk* form of Sumproduct will recognize text numbers, where as
the
unary form will not.

If A1:A50 are "text" numbers,
=SUMPRODUCT((B1:B50="CAT")*A1:A50)
*Will* total Column A

Where as,
=SUMPRODUCT(--(B1:B50="CAT"),A1:A50)
Will *not*!

=SUMPRODUCT(--(B1:B50="CAT"),--(A1:A50))

But I think the OP just wants

=SUMPRODUCT(--(A1:A50))