# SUMIF accross multiple sheets

#### SusaninHouston

##### Active Member
I have a workbook with 1 sheet per month and a YTD total. The 12 monthly sheets hold the same data in the same format, but possibly in a different order each month. (Think sales results for a team of salespeople listed in descending order.)

I want the YTD sheet to sum results for each salesperson across the 12 monthly sheets.

I can get the answer I want using =SUMIF(Sheet 1... ) + SUMIF(Sheet 2...) type language, but my formula is too long.

Is there a neat way to do this?

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
My suggestion is to name the different ranges of data. For example, Sheet1!\$A\$1:\$P:\$456 you might name January. After you assign the data that name, you can reference the name January in formulas rather than the sheet name plus cell range.

Quick way to do this is to highlight the range of data, and type in a name in the cell reference box directly above column A. You may use Offset functions to expand the data range to fit a max number of rows if the data range is likely to change.

May not shorten your formula much, but at least makes it easier to see what the formula is doing.

Tried both suggestions -- They both work and they're both Great!

Thanks

I have the same issue and noticed that you have helped many others with the link you provided above. I have clicked on the link from several posts but it does not seem to work any longer. Any chance you could provide the solution again please? Just for reference, all I'm trying to do is sum information in 60+ tabs into a summation lead sheet and all of the data is in the same range in each tab.

Thank you,
Jimean

Replies
4
Views
140
Replies
0
Views
98
Replies
4
Views
184
Replies
20
Views
578
Replies
5
Views
214

1,202,987
Messages
6,052,939
Members
444,616
Latest member
novit19089

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back