Vlookup? Sumif? Combination? Any help appreciated!

[nzkaren]

Hi

I am working with financial data and want to create a summary sheet showing the total monthly (column B) and year to date (column E) costs for each Region.

I have one file per region, each with a differing number of cost centres, each on their own sheet. For example, Asia has 5 sheets of cost centre results while the US has 2 sheets of cost centre results. Adding to the difficulty is that the Total line I am trying to report is on different lines for each cost centre, i.e. Asia report on lines 81, 30, 42, 55, 60.

Could anyone tell me how to formularise this? Any help much appreciated!

 

[Robert Mika]

Hi Karen,
What I would do is to copy first all cost centres into one sheet(All cost centre columns one under another) and then extract Unique items

Having this you can use this tip

http://help.wugnet.com/office/SUMIF-multiple-worksheets-ftopict1157402.html

SUMIF with SUMPRODUCT works for me ideally.