add the same cell on several worksheets to another worksheet
 

what i want to do is be able to add a cell like D3 on 53 different worksheets
and place the sum on another workssheet in the same workbook. easiest way to
explain is i need a weekly report and want to toal the same cell to a year
end report in the same workbook.

In the Summary sheet, type equal sign and sum plus one parenthesis

=SUM(

select the first sheet tab, hold down shift and select the last sheet tab,
click D3 and press enter you will get

=SUM(Sheet1:Sheet53!D3)

of course your sheet names are probably week numbers or something

Regards,

Peo Sjoblom

"tea1952" wrote:

what i want to do is be able to add a cell like D3 on 53 different worksheets
and place the sum on another workssheet in the same workbook. easiest way to
explain is i need a weekly report and want to toal the same cell to a year
end report in the same workbook.