Thread: worksheet

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.

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

"hoachen" wrote:

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