### Tags: across, cell, contains, excel, formulas, microsoft, msdn, sheet, sheets, software, specific, summary, totals, workbook, worksheets

# Formulas Across Sheets

On Microsoft » Microsoft Excel

2,510 words with 3 Comments; publish: Wed, 04 Jun 2008 11:51:00 GMT; (30678.13, « »)

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

*http://excel.todaysummary.com/q_microsoft-excel_192221.html*

All Comments

Leave a comment...

- 3 Comments
- =SUM(Sheet1:Sheet60!A1)
HTH

Jason

Atlanta, GA

>--Original Message--

>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

>.

>

#1; Wed, 04 Jun 2008 11:52:00 GMT

- =SUM(Sheet1:Sheet60!A1)
- 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)

--

Regards,

Peo Sjoblom

"Smita" <anonymous.excel.todaysummary.com.discussions.microsoft.com> wrote in message

news:346201c3e1ee$799f87b0$a401280a.excel.todaysummary.com.phx.gbl...

> 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

>

#2; Wed, 04 Jun 2008 11:53:00 GMT

- Type equal sign and part of the formula in the summary cell
- Smita-
Try this

=SUM(Sheet2:Sheet60!A1)

>--Original Message--

>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

>.

>

#3; Wed, 04 Jun 2008 11:54:00 GMT

- Smita-