I resubscribed in case my membership lapsed when I changed to satellite, and
I will re-ask my question in case the last attempt did not get through..
I have created a cashbook using Calc (ver 2.3) and it is working fine. The
column headers are:
code date description amount
If I want to get a total for all of my vehicle expenses, I can use this
formula:
=SUMIF(NAB.A7:NAB.A2001; "v"; NAB.E7:NAB.E2001)
where:
NAB is the name of the sheet
A7:A2001 the range
"v" is the code I use for vehicle expenses
What I want to do now, for my accountant, is to sum all the expenditure in a
particular category, between two given dates, so, if I have put the Start
Date in cell G1, and the End Date in G2, in pseudocode this is what I want
to achieve:
=SUMIF((A7:A2001 = "V") AND (G1<B7:B2001<G2); sum E7:E2001)
I want to add up all expenses that match a particular code and occurred
between specified dates.
I am sure I can use an array formula (registered using Ctrl+Shift+Enter) but
I cannot seem to get one to work and I would appreciate it if you could
point me in the right direction.
Many thanks, James.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
