Formulas Across Sheets

  • Thread starter Thread starter Smita
  • Start date Start date
S

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
 
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)
 
Back
Top