James Elliott - WA Rural Computers wrote:
...
ie. I made it read:
=SUMPRODUCT(chqDEBIT,chqCODE=A13,chqDATE>=$D$4,chqDATE<=$D$5)
and the formula no longer worked! The sumproduct total I had in that
cell just disappeared - no error message, just no result.
If you're working in Calc then you n
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
numeri
inal Message -
From: "Joe Smith" <[EMAIL PROTECTED]>
To:
Sent: Friday, September 19, 2008 11:54 PM
Subject: [users] Re: INTERESTING SUMPRODUCT OBSERVATION.?
Joe Smith wrote:
James Elliott - WA Rural Computers wrote:
When I saved a Calc spreadsheet in Excel format to send to my
total I had in that cell
just disappeared - no error message, just no result.
Kind regards, James
- Original Message -
From: "Joe Smith" <[EMAIL PROTECTED]>
To:
Sent: Friday, September 19, 2008 11:09 AM
Subject: [users] Re: INTERESTING SUMPRODUCT OBSERVATION.?
Joe Smith wrote:
James Elliott - WA Rural Computers wrote:
When I saved a Calc spreadsheet in Excel format to send to my
Accountant, the SUMPRODUCT formulas did not work because a Calc
formula like this:
=SUMPRODUCT(A1:A3000; B1:B3000)
was converted to :
=SUMPRODUCT(A1:A3000, B1:B3000)
ie sem
James Elliott - WA Rural Computers wrote:
When I saved a Calc spreadsheet in Excel format to send to my
Accountant, the SUMPRODUCT formulas did not work because a Calc formula
like this:
=SUMPRODUCT(A1:A3000; B1:B3000)
was converted to :
=SUMPRODUCT(A1:A3000, B1:B3000)
ie semicolons ";" replac