I have several worksheets for different places which each have budget
information regarding how much ‘Amount’ and when a payment is due ‘Date’. I
am trying to create a ‘totals’ spreadsheet which will collect the relevant
information from each spreadsheet so I can total the amount due for each
month due and if values change in the separate spreadsheets with therefore
update the ‘totals’ spreadsheet. VLOOKUP has been suggested but the months
vary in each spreadsheet and therefore their cell locations vary. I need the
formula to look for the specified month e.g. 01-Dec-05, then collect the
amount from the adjacent cell and put that information into my 'totals'
sheet. I have also tried naming the columns and using SUMIF
(=SUMIF(London_Date, ''01-Dec-05'', London’!G:G) but it seemed to work for
one spreadsheet and now I can’t get it to work for the next spreadsheet?

I’ve been through my excel formulas book and the office assistant but I’m
really stuck and this should have been done last week! Any suggestions?

Thank you for your help

Kim