Autofill formulas b/t various worksheets

  • Thread starter Thread starter lbenson
  • Start date Start date
L

lbenson

Hello-

I have a workbook w/ 25 worksheets.

I need to sum the same cell from each worksheet and put it on a
separate summary worksheet. I tried to use the formula
='Sheet1'B3+'Sheet2'B3+'Sheet3'B4 and then tried to autofill that
formula all the way down to get the sum for all 25 sheets.

However, all this did was repeat the same 3 numbers over & over.

Does anyone have any suggestions? I need to do this for many different
cells and it would take forever to select each cell.

Thanks for your help.

Lee
 
You could try:

=SUM(Sheet1:Sheet25!B3)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hello-

I have a workbook w/ 25 worksheets.

I need to sum the same cell from each worksheet and put it on a
separate summary worksheet. I tried to use the formula
='Sheet1'B3+'Sheet2'B3+'Sheet3'B4 and then tried to autofill that
formula all the way down to get the sum for all 25 sheets.

However, all this did was repeat the same 3 numbers over & over.

Does anyone have any suggestions? I need to do this for many different
cells and it would take forever to select each cell.

Thanks for your help.

Lee
 
Back
Top