How do I set a formula to add a cell in seperate worksheets to di.

[Guest]

I want to add a cell from different worksheets with the total displayed on a
summary worksheet in the same file.

A little detail.

I have serveral worksheets in one file. I want to add a cell in all the
worksheets to give me a total on a summary worksheet in the same file.

 

[jack]

This is only can be possible if the cell is the same cell
on all worksheet. Otherwise the formula needs to be keyed
in manually.

 

[Frank Kabel]

Hi
do you mean
=SUM('sheet1:sheet10'!A1)

 

[Guest]

Yes! Its the same cell just different worksheets. I want to sum theses cells
on one summary worksheet. Can this be done and How? email:
(e-mail address removed)

Thank you so much Frank!

 

[Guest]

yes! It's the same cell on all the worksheets (e.g. sheet1, sheet2), I want
to sum the cell in these worksheet and have it on a summary worksheet in the
same file. Can I do this and how? Thanks Jack

 

[Myrna Larson]

You do it with a formula like Frank showed you.

Yes! Its the same cell just different worksheets. I want to sum theses cells
on one summary worksheet. Can this be done and How? email:
(e-mail address removed)

Thank you so much Frank!

 

[Guest]

I have 35 sheets and the cell is D26 on each sheet. Is the correct formula
=Sum('sheet1:sheet35'!D26). I tried this and I recieved #ref error. Please
help me!

 

[Frank Kabel]

Hi
this formulas should work if sheet1 is the first and sheet35 the last
sheet. Try entering the formula the following way:
- insert =SUM(
- now select cell D26 on the first sheet
- hold down the sHIFT key and select the last sheet
- hit ENTER

--
Regards
Frank Kabel
Frankfurt, Germany

I have 35 sheets and the cell is D26 on each sheet. Is the correct formula
=Sum('sheet1:sheet35'!D26). I tried this and I recieved #ref error. Please
help me!

file.