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. There are no problems with the sheets which detail my
differing bank account and credit card transaction lists, but the most
important page, the REPORT PAGE, dies not work.
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
Excel does have a SUMPRODUCT( ) formula but my Calc version of SUMPRODUCT
formula does not work in Excel. If I take out the qualifying parameters I
do get a total, but without the filters that total is meaningless to the
accountant.
If anyone can educate me on why the Cal version of SUMPRODUCT does not work
in Excel, and what I have to do to make it work, I would be very much
obliged.
Many thanks, James
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
