Transfer data from sheet to sheet

[Chris Watson]

Hi
Im trying to transfer data from sheet to sheet ie: I have inputed data
on the same cell (C3) on 6 seperate sheets and want to add all the
cells together on the 7th

Can anybody help

Chris

 

[Don Guillett]

try
=sum(sheet1:sheet6!c3)

 

[Paul]

Hi
Im trying to transfer data from sheet to sheet ie: I have inputed data
on the same cell (C3) on 6 seperate sheets and want to add all the
cells together on the 7th

Can anybody help

Chris

In C3 of Sheet7 type the formula
=SUM(Sheet1:Sheet6!C3)
If you have renamed the sheets, just substitute your names for the first and
the last sheets.
Note that this will sum the values on all sheets positioned between the
first and last (inclusive of the first and last). In other words, if you
alter the order of your sheets so that different ones (or more sheets, or
fewer sheets) are positioned between first and last, your formula result
will change.

 

[Don Guillett]

In response to a direct question from OP

Chris.
1. You should keep the questions in the ng unless invited otherwise
2. If invited you should copy/paste the entire question so that the
responder will know what you are talking about. I had to do a search to find
your original question.
3, I see that another responder, if fact, answered the obvious.

If you have renamed the sheets, just substitute your names for the first and
the last sheets.

SO if you assume that Sunday is the 1st and Saturday is the last.
=sum(Sunday:Saturday!c3)

try
=sum(sheet1:sheet6!c3)


--
Don Guillett
SalesAid Software
(e-mail address removed)

try
=sum(sheet1:sheet6!c3)