Copy data in multiple worksheets

K

kfletchb

How do I put the total of a row(column) of numbers from one worksheet to
another worksheet?
Mahalo.
Karen
 
M

Mark

kfletchb said:
How do I put the total of a row(column) of numbers from one worksheet to
another worksheet?
Mahalo.
Karen
Click to expand...

Use something like this:

=SUM(Sheet1!B1:B25)

Change the value "Sheet1" to the name of your worksheet
Change the value "B1:B25" to the cells that you are adding
DON'T FORGET THE EXCLAIMATION POINT AFTER THE WORKSHEET NAME
 
K

kfletchb

great. thanx mark

Mark said:
Use something like this:

=SUM(Sheet1!B1:B25)

Change the value "Sheet1" to the name of your worksheet
Change the value "B1:B25" to the cells that you are adding
DON'T FORGET THE EXCLAIMATION POINT AFTER THE WORKSHEET NAME
Click to expand...
 
Top