Dear all,

A B
1 Item Number
2 x 1
3 y 2
4 x 3

SumProduct(--(A1:A4="x"),(B1:B4)) gives the correct answer 4.

However, SumProduct((A1:A4="x"),(B1:B4)) gives the incorrect answer,
it incorrectly gives 0.

Any idea why?


Thanks,

Wing