Trying to figure out what the -- mean in this formula. = sumproduct(--(d2:d5=a2 etc. . . . Thank you
J Jennifer Nov 15, 2004 #1 Trying to figure out what the -- mean in this formula. = sumproduct(--(d2:d5=a2 etc. . . . Thank you
J JulieD Nov 15, 2004 #2 Hi Jennifer there's a bit of a write up on it at the bottom of the discussion on sumproduct generally at http://www.xldynamic.com/source/xld.SUMPRODUCT.html just before the examples, maybe this will help Cheers JulieD
Hi Jennifer there's a bit of a write up on it at the bottom of the discussion on sumproduct generally at http://www.xldynamic.com/source/xld.SUMPRODUCT.html just before the examples, maybe this will help Cheers JulieD
B Bob Phillips Nov 15, 2004 #3 http://www.xldynamic.com/source/xld.SUMPRODUCT.html#format takes you straight there. -- HTH RP (remove nothere from the email address if mailing direct) JulieD said: Hi Jennifer there's a bit of a write up on it at the bottom of the discussion on sumproduct generally at http://www.xldynamic.com/source/xld.SUMPRODUCT.html just before the examples, maybe this will help Cheers JulieD Click to expand...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html#format takes you straight there. -- HTH RP (remove nothere from the email address if mailing direct) JulieD said: Hi Jennifer there's a bit of a write up on it at the bottom of the discussion on sumproduct generally at http://www.xldynamic.com/source/xld.SUMPRODUCT.html just before the examples, maybe this will help Cheers JulieD Click to expand...