worksheet

[Guest]

Currently I have 4 worksheets on my workbook. I am looking for the tutorial
about how to calculate the different worksheet. Meaning, how can i add up a
specific column of this 4 worksheets. For example,
worksheet 1 column 3 have the value $50
worksheet 2 column 3 have the value $100
worksheet 3 column 3 have the value $50
worksheet 4 column 3 have the value $30

The total is $230

I know I can just put on the column $50+$100+50+$30 = $230 BUT
when i make changes on worksheet 3 value $100 then I have to change
50+$100+100+$30 =$280.

Do you guy have any suggestion how the worksheet change will automatically
change the total value column when other worksheet value is change?

Please give you precious advice and suggestion. i would very appreciate.

 

[Guest]

One way is to add to "dummy" sheets named (for example) "Start" & "End".
Place the sheets to be summed etc between these two tabs i.e
Start,Sheet1,Sheet2 ....,End.


In your summary sheet, which is (obviously) not in the Start/End block, use:

=Sum(Start:End!A1:A5)

This will sum cells A1 to A5 on all worksheets.

=Sum(Start:End!C:C)

will sum Column C on all worksheets i.e. this could be your total cell.

HTH