finding cells on diferance sheets

[duckie]

Could someone please help
I have on sheet 2 in column D names of cities the vary like Sydney
Brisbane could be twice but each week the cells could have difference
city in them.
In column F it will have a number in them a difference number each
week
I need the total of the number that matches the city added up on sheet
1 that matches the city in sheet 1 which on sheet one the city never
moves

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.