i have several columns, for profit costs, VAT etc, on a seperate sheet within
the same workbook i want to create a summary sheet which totals all of the
profit costs that fall within each month.

i.e. sum of profit costs for february.

i have tried for hours without success, this is my current effort:

=SUM(IF(('Adam Burton - Costs Recovered.xls'!Date"31/12/2004")+('Adam
Burton - Costs Recovered.xls'!Date<"01/02/2005"),Paid!D4:D1000))

can anyone please help!?

Neil