How to sum with criteria across various sheets in workbook?

Hello,

I have a question regarding summing data from various sheets within the same work book.
(i.e. wanted to create a summary sheet that pulls in data from the other tabs in the workbook. Each of the tabs represent a month). Would like to implement criteria since the data involves various departments and I figured it would be a good idea.

For now, I can only think of using the sumifs function while referencing to each tab.

Thank you in advance.

P.S. I've attached a sample book.

Originally Posted by mehmetcik

Aha

This could be very easy.

It's just that the actual file I have is ginormous, with many additional rows & columns. As an approach, I tried my best to break it down in various ways, but I am a beginner w/ the Excel formulas.

I went as far as trying to put everything in one sheet, so that the sumif formula would be easier to manage, but the data made the sheet unpleasant to work with. thanks.

Originally Posted by mehmetcik

Enter this formula in cell C2 of your summary sheet.

Formula: Select Code
=SUM('* 2000'!C2)


This is an example of a multipage formula.

http://www.artifax.net/excel/excel-t...le-worksheets/

This like what you need:-

http://www.notjustnumbers.co.uk/2014...ll-across.html

Thanks, is there a way I can put some sort of criteria in the formula you provided? The reason is because more likely than not, the rows/columns in the monthly tabs are usually in no particular order. Sorry about the confusion.

Instead of just pointing to the cell, I hope to use "Location" & "Dept" as the criteria.