Copy data in multiple worksheets

's Computer Specifications

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

's Computer Specifications

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

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

's Computer Specifications

great. thanx mark

"Mark" wrote:

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy data from 1 sheet to multiple worksheets	Rob P	Microsoft Excel Programming	2	15th Apr 2009 07:14 PM
how to copy data from one worksheet to multiple worksheets at once	zeb	Microsoft Excel Worksheet Functions	2	21st Oct 2008 08:25 PM
Copy data from multiple worksheets to worksheets in a number of other spreadsheets	SteveH	Microsoft Excel Discussion	5	6th Nov 2006 07:59 PM
copy data across worksheets and add multiple lines	madwoman	Microsoft Excel Programming	0	13th Aug 2006 02:35 PM
Copy only certain data from multiple worksheets	=?Utf-8?B?TWF0dA==?=	Microsoft Excel Misc	0	10th Feb 2006 04:06 PM