rowwise total!

[via135]

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

 

[Guest]

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

 

[ChuckF]

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]

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]

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

 

[John James]

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

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

 

[via135]

thks Mr John!

this is what I exactly wanted!!

thanks again!

-via13