<<"How about the comma vs star syntax/form?"

I'm missing your point?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Aladin Akyurek" wrote in message
...
Ragdyer wrote:
[...]

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*!

Unary form? You mean of course SumProduct's native comma syntax for the
coercer that is needed can be any of +0, *1, ^1, N, or --. How about the
comma vs star syntax/form?