Excel Formula

[Glenn]

I have an Excel workbook, within the workbook there are 17
different sheets the first 16 sheets run one after each
other the first sheet is called Pat Pettett and the 16th
sheet is called Sue Fisher. On the 17th sheet in cell 1 I
want to put a formula that will add up cell C10 from the
first 16 sheets.

 

[Katherine Coombs]

Hi Glenn,

You're after a 3D Reference.
1.. Click the cell where you want to enter the function.
2.. Type = SUM(
3.. Click the tab for the first worksheet to be referenced.
4.. Hold down SHIFT and click the tab for the last worksheet to be
referenced.
5.. Select the cell or range of cells to be referenced - in this case cell
C10 - and press ) to close the parentheses.
6.. Press ENTER.
HTH,
Katherine