Sumif apllying to all sheets in workbook

[wdstylr]

Ok
I have searched the forum and I can't seem to find an answer that solve
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 5
tabs)(minus the sheet I am totaling on)
I also add new tabs regularly and would like the formula to continu
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 ever
other tab the employee number is listed in column N (which is why
believe this should be my range).

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

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

Any help much appreciated.
Thank yo

 

[yogvjti]

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

 

[Don Guillett]

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

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