Hi sebastienm,
"sebastienm" wrote
= sumproduct( ($A$2:$A$100=1) * ($B$1:$B$B10030) * 1)
your *1 is redundant as the two equations return arrays of TRUE/FALSE and
those when multiplied by each other are coerced to 1/0. Thus SUMPRODUCT sums
up an array of 1s and 0s.
Regards,
KL
|