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

T

Tim

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.
 
J

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.
 
T

Tim

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!
 
T

Tim

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
 
M

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!
 
T

Tim

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!
 
F

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

Tim said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top