Copy data in multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I put the total of a row(column) of numbers from one worksheet to
another worksheet?
Mahalo.
Karen
 
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
 
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...
 
Back
Top