Harold
I do not have Brian Barker's previous answer and would be obliged if you
could forward it again please, as I have been waiting 24 hours for some help
and yours is the only reply I have received.
James
----- Original Message -----
From: "Harold Fuchs" <[EMAIL PROTECTED]>
To: <[email protected]>; <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2007 9:40 AM
Subject: Re: [users] CALC FORMULA QUESTION.?
On 26/11/2007 06:08, James Elliott - WA Rural Computers wrote:
I have a spreadsheet cashbook that I designed and implemented in OOo Calc
ver 2.3 running under Windows XP.
I list all my transactions in columns like this:
code date description amount
v 5/6/07 vehicle expenses $59.70
i 10/8/07 income $95.00
On another sheet within the same workbook I summaries of all the money
spent
or earned in the differing categories, for my accountant. For example,
my
formula to calculate the sum of all vehicle expenses is:
=SUMIF($NAB.$A$7:NAB.$A$2001; "v"; $NAB.$E$7:$NAB.$E$2001)
and my formula for adding up my taxable income is:
=SUMIF($NAB.$A$7:NAB.$A$2001; "i"; $NAB.$F$7:$NAB.$F$2001)
where NAB is the name of the Sheet on which the transactions are listed
What these formulas do, using the vehicle one as an example, is to add up
all amounts coded with a "v". What I want to do now is to be able to
specify a date range so i can ask Calc to give me a total for vehicle
expenses incurred between the two dates. If I enter the Start Date in
D5,
and the End Date in D6, in pseudo-code, this is what I want:
SUMIF( NAB.A7:NAB.A2001; "v" AND (TransactionDate=>StartDate) AND
(TransactionDate=<EndDate); sum-range)
I think you can combine conditions using the * operator eg
(.........)*(...........) but I can't find my way back to that bit in the
help files.
I would be very much obliged if any of you could point me to an elegant
solution to my problem.
Many thanks, James
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
I forwarded Brian Barker's previous answer to you
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
--
No virus found in this incoming message.
Checked by AVG Free Edition. Version: 7.5.503 / Virus Database:
269.16.8/1153 - Release Date: 26/11/2007 9:08 PM
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
