Sumif apllying to all sheets in workbook
 

Ok
I have searched the forum and I can't seem to find an answer that solves my problem, or at least one that I can implement.

I am trying to write a sumif formula that will do the following:

1. Use the range of all N columns in my entire workbook (under 50 tabs)(minus the sheet I am totaling on)
I also add new tabs regularly and would like the formula to continue applying to them without having to modify it every time I add a tab.

2. Use the criteria of an employee number (ex. 141).
On my total sheet the employee numbers are listed in column A. On every other tab the employee number is listed in column N (which is why I believe this should be my range).

3. Im trying sum all the numbers in column S, of all the individual tabs, into the "=" cell in my "totals" tab.

I have tried everything I can find online and continue to get errors. Is it possible to do this way or do I need to try a different function?

Any help much appreciated.
Thank you

Sumif apllying to all sheets in workbook
 

Hi,
Ans to your first ques is ;

Go to your outputsheet wherever you want the summation of all the sheets.
Type...Sum('firstsheetname:lastsheetname'!a1) and drag the formula vertically as well as horizontally.

and in future need arise to insert additional sheet just ensure that the new sheet is not the extreme right or left sheet...i.e. it should be inserted somewhere inbetween.

Hope this solves ur problem.

YM

Sumif apllying to all sheets in workbook
 

On Tuesday, January 21, 2014 11:08:33 PM UTC-6, wdstylr wrote:
Ok

I have searched the forum and I can't seem to find an answer that solves

my problem, or at least one that I can implement.



I am trying to write a sumif formula that will do the following:



1. Use the range of all N columns in my entire workbook (under 50

tabs)(minus the sheet I am totaling on)

I also add new tabs regularly and would like the formula to continue

applying to them without having to modify it every time I add a tab.



2. Use the criteria of an employee number (ex. 141).

On my total sheet the employee numbers are listed in column A. On every

other tab the employee number is listed in column N (which is why I

believe this should be my range).



3. Im trying sum all the numbers in column S, of all the individual

tabs, into the "=" cell in my "totals" tab.



I have tried everything I can find online and continue to get errors. Is

it possible to do this way or do I need to try a different function?



Any help much appreciated.

Thank you









--

wdstylr

This works IF?? you have a sumif for each sheet in a1 of each sheet. Else, NO