James Elliott - WA Rural Computers wrote:
...
So, in Calc (forget Excel) we can use either of these formats, can we?:
=SUMPRODUCT(A1:A3000; D1:D3000<=TEST)
or
=SUMPRODUCT((A1:A3000)*(D1:D3000<=TEST))
Am I correct?
Yes, I believe that is correct. Logical tests in Calc always produce
numeric 0 or 1, so the simple arguments will work fine for Calc.
That's not true for Excel, so if you need to move the same sheet between
Calc and Excel, you must use the second form to force the logical test
results to be converted to 0 or 1. It isn't /needed/ for Calc, but it
works the same on both.
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
