Using "--" as an array formula shortcut / alternative
On Feb 5, 1:12*pm, Ollie4 wrote:
so what does
sumproduct(--(A1:A1000="West"),--(B1:B1000="Blue"),C1:C1000)
deferrer from
sumproduct((A1:A1000="West")*(B1:B1000="Blue")*(C1 :C1000))?
Related question:
Why does the "*" work, but if you use "," instead you don't get the
right answer. I thought sumproduct multiplied the entries so in a
way, I thought they'd still get multiplied "the right way".
PS, thanks for the link Bob Phillips.
|