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