In some situation, it is necessary. Not in this particular case, that's true,
but i prefer to keep the '* 1' so that i don't spend too much time searching
the source of a 'wrong' result.
Eg: Say you have a list of strings, dates, numbers,... in A1:Ax
=SUMPRODUCT((LEN(A4:A7)3))
--- returns 0 whether or not the text in a cell has a length greater
than 3
Now try
=SUMPRODUCT((LEN(A4:A7)3) * 1)
--- here, you get the right result.
--
Regards,
Sébastien
"KL" wrote:
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
|