Sum cells across different work sheets

[Jamie1990]

Hello,

I have a issue, I have a spreadsheet where we have multiple sheets each of the data shows our sites with hours quote and hours spent. Each sheet is different in that some months sites will not show as the maintenance was not raised.

My supervisor wants a summary page and cannot for the life of me figure out how to show a sum of the quote hours that is site specific.

Help!

Jamie

[FDibbins]

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like?

You would probably need to do something like this...
1. create s list of all your sheet names
2. give that list a range name (I used BldTabs, you can use what you want, just change it in teh formula below
3. use this formula - adjust ranges and references as needed...
=SUMPRODUCT(SUMIF(INDIRECT("'"&BldgTabs&"'!T6:T1000"),C794,INDIRECT("'"&BldgTabs&"'!M6:M1000")))

[Jamie1990]

Hi,

Here is a sample file, Hopefully it will help with solving this!

Jamie