Transfer data from sheet to sheet

  • Thread starter Thread starter Chris Watson
  • Start date Start date
C

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
 
Chris Watson > said:
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
Click to expand...

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.
 
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.
Click to expand...
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)
Don Guillett said:
try
=sum(sheet1:sheet6!c3)
Click to expand...
 
Back
Top