Formulas Across Sheets

[Smita]

I have a workbook with about 60 worksheets and a summary
sheet. The summary sheet contains totals of a specific
cell in each of the 60 sheets. One way to do is the long
way by typing the whole formula. But is there any better
way which would make it more legible? For example, using
=sum() function across sheet. The row and col. coordinates
would be same in each of the 60 sheets.

Thanks,
Smita

 

[Jason Morin]

=SUM(Sheet1:Sheet60!A1)

HTH
Jason
Atlanta, GA

 

[Peo Sjoblom]

Type equal sign and part of the formula in the summary cell

=SUM(

click on the first sheet tab that you want to use

hold down shift and click on the last sheet tab,

select the range you want to sum and press enter

formula will for example look like

=SUM(First:Last!A1:A100)

 

[Paul]

Smita-
Try this
=SUM(Sheet2:Sheet60!A1)