rowwise total!

rowwise total!

Post by via13 » Wed, 29 Mar 2006 04:30:02



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/
View this thread: http://www.yqcomputer.com/
 
 
 

rowwise total!

Post by RWxrYX » Wed, 29 Mar 2006 05:22:02

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!

Post by Chuck » Wed, 29 Mar 2006 05:33:16

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!

Post by via13 » Wed, 29 Mar 2006 14:42:24


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/
View this thread: http://www.yqcomputer.com/
 
 
 

rowwise total!

Post by via13 » Thu, 30 Mar 2006 14:25:53


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/
View this thread: http://www.yqcomputer.com/
 
 
 

rowwise total!

Post by John Jame » Fri, 31 Mar 2006 07:58:03


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/
View this thread: http://www.yqcomputer.com/
 
 
 

rowwise total!

Post by via13 » Sat, 01 Apr 2006 03:56:15


thks Mr John!

this is what I exactly wanted!!

thanks again!

-via13