Add ROWS
 

Hi,
I need to add the number which is there in the row.

for example..

Code:
--------------------

0 4 2 1 0 0 0 2

--------------------

and i need to add those values
how to do it in Excel instead of doing it manully?


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=484500

Add ROWS
 

i presume that the eight number are from A1 to H1

then try some thinglike this codestatement

Range(Range("a1"), Range("a1").End(xlToRight)).Copy Destination:=Range("a5")

or

Rows("1:1").Copy
Rows("7:7").PasteSpecial


"jayender.vs"
wrote in message
...

Hi,
I need to add the number which is there in the row.

for example..

Code:
--------------------

0 4 2 1 0 0 0 2

--------------------

and i need to add those values
how to do it in Excel instead of doing it manully?


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile:
http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=484500

Add ROWS
 

Do you mean

=SUM(5:5)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jayender.vs"
wrote in message
...

Hi,
I need to add the number which is there in the row.

for example..

Code:
--------------------

0 4 2 1 0 0 0 2

--------------------

and i need to add those values
how to do it in Excel instead of doing it manully?


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile:
http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=484500