At 08:44 10/09/2008 +0800, James Elliott wrote:
I have a Calc spreadsheet bookkeeping system which works well for
me. I have to save it in Excel format to send to my accountant so
he can access and read it.
No: you don't have to do this. If he needs only to access and read
your spreadsheet, exporting it as PDF may well be a better option and
may solve our problem. It even protects what he sees from
unintentional changes made by him. Or does *he* need to change the
date options and so on?
On this report page you enter a start date and an end date and the
totals for differing categories are displayed. In Calc, I use the
SUMPRODUCT formula, as in this example:
=SUMPRODUCT(chqDEBIT, chqCODE="b", chqDATE>=$D$4, chqDATE<=$D$5)
where this formula adds up all the cheque account DEBITS where the
category code is "b" and the transaction falls between the Start
Date D4 and the End Date D5
This formula doesn't work in Calc, in fact: it needs the parameters
to be separated by semicolons, not commas.
Excel does have a SUMPRODUCT( ) formula but my Calc version of
SUMPRODUCT formula does not work in Excel.
I'm puzzled by this. I've tested it exhaustively and I cannot get it
(with the semicolons) not to work! I don't have Excel in which to
examine the resulting .xls file, but it shows up properly in the free
Excel Viewer and opens satisfactorily in Calc again. Your problem
may be something other than the SUMPRODUCT() function. And you may
have to explain exactly in what way it "does not work" if anyone is
to be able to help.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
