Selecting date specific data from different spreadsheets

[Guest]

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

 

[Jim Rech]

but it seemed to work for one spreadsheet and now I can't get it to work
Rather than look for a single formula that does it all, I think you should
get a working formula on each sheet and then sum those on the totals sheet.


--
Jim
|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
|