SUMPRODUCT use of --() syntax

[Stephen Lloyd]

I was wondering if someone could explain to me how the --() syntax works.
Also the use of SUMPRODUCT((condition1)*(condition2)).

 

[Mike H]

Stephen,

The use of Sumproduct and the double unary are explained here

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Mike

 

[Stephen Lloyd]

Thanks Mike, that was a great explanation.

Stephen,

The use of Sumproduct and the double unary are explained here

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Mike