S Stephen Lloyd Jun 27, 2008 #1 I was wondering if someone could explain to me how the --() syntax works. Also the use of SUMPRODUCT((condition1)*(condition2)).
I was wondering if someone could explain to me how the --() syntax works. Also the use of SUMPRODUCT((condition1)*(condition2)).
M Mike H Jun 27, 2008 #2 Stephen, The use of Sumproduct and the double unary are explained here http://www.xldynamic.com/source/xld.SUMPRODUCT.html Mike
Stephen, The use of Sumproduct and the double unary are explained here http://www.xldynamic.com/source/xld.SUMPRODUCT.html Mike
S Stephen Lloyd Jun 27, 2008 #3 Thanks Mike, that was a great explanation. Mike H said: Stephen, The use of Sumproduct and the double unary are explained here http://www.xldynamic.com/source/xld.SUMPRODUCT.html Mike Click to expand...
Thanks Mike, that was a great explanation. Mike H said: Stephen, The use of Sumproduct and the double unary are explained here http://www.xldynamic.com/source/xld.SUMPRODUCT.html Mike Click to expand...
