rowwise total!

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.yqcomputer.com/

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

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:

--
via135
------------------------------------------------------------------------
via135's Profile: http://www.yqcomputer.com/

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.yqcomputer.com/

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.yqcomputer.com/

rowwise total!

thks Mr John!

this is what I exactly wanted!!

thanks again!

-via13