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; (306186.52, « »)

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

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
    • 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
    • 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