how do i sum the same cell in numerous sheets behind a main

  • Thread starter Thread starter njparamedic
  • Start date Start date
N

njparamedic

i am preparing a master worksheet to roll up numerous jobs. i want to add
all cells in the same position behind the master sheet. is there a sum
fourmula to accomplish this?
 
Hi,
If the totals are in the same position use

=SUM(Sheet1:Sheet3!A1)

Sheet1 is the first sheet in your workbook, Sheet3 is the last one,
A1 is the cell you want to summarize
Change the above to fit your needs. you can do it going to the cell where
you want to summarize and enter =sum(
then click in the first sheet you want to summarize, press the shift key,
hold it and click on the last sheet, then choose the cell to summarize and
enter )
 
Hi,
If the totals are in the same position use

=SUM(Sheet1:Sheet3!A1)

Sheet1 is the first sheet in your workbook, Sheet3 is the last one,
A1 is the cell you want to summarize
Change the above to fit your needs. you can do it going to the cell where
you want to summarize and enter =sum(
then click in the first sheet you want to summarize, press the shift key,
hold it and click on the last sheet, then choose the cell to summarize and
enter )
 
Back
Top