rowwise total!
 

hi!

i am having numbers in A1:E5 and want the totals in A6:E6
as under:

A1:E1 in A6,
A2:E2 in B6
A3:E3 in C6
A4:E4 in D6
A5:E5 in E6

hlp pl?

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=526845

rowwise total!
 

Just use the SUM function for whatever range you want. So, in A6 enter the
following formula:

=SUM(A1:E1)

And in cell B6 enter:

=SUM(A2:E2)

etc, etc...

HTH,
Elkar


"via135" wrote:


hi!

i am having numbers in A1:E5 and want the totals in A6:E6
as under:

A1:E1 in A6,
A2:E2 in B6
A3:E3 in C6
A4:E4 in D6
A5:E5 in E6

hlp pl?

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=526845

rowwise total!
 

A6 should be =sum(A1:E1)
B6 should be =sum(A2:E2)
C6 should be =sum(A3:E3)

and so on and so on.

rowwise total!
 

hi!

the thing is that i want the job done with using autofill from A6:E6
since i'm having numbers in more than 50 Columns??!!

-via135

ChuckF Wrote:
A6 should be =sum(A1:E1)
B6 should be =sum(A2:E2)
C6 should be =sum(A3:E3)

and so on and so on.


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=526845

rowwise total!
 

reminding for help!

-via135




hi!

the thing is that i want the job done with using autofill from A6:E6
since i'm having numbers in more than 50 Columns??!!

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=526845

rowwise total!
 

Say the first column is "A" and the last column is "AX" (giving 50
columns). The formula is:

=SUM(INDIRECT("A"&COLUMN()&":AX"&COLUMN()))


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=526845

rowwise total!
 

thks Mr John!

this is what I exactly wanted!!

thanks again!

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=526845