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]
