A B C D E F G H I J
1
2
etc
48
49 totals....................


In row 50, put the formula

=a49 =b49 =c49 and drag across as far as you need, this will give you
the formulas you want. Go back to each and add in the absolute
reference or =$a$49, =$b$49 (I found it would give me a REF# error if I
didn't, though it may work for you)

Copy the whole range you want. Go to the column and cell you want for
the originating cell and edit /paste special / select radio for
formulas and box for transpose.

This should paste down the colum with the totals as you want it.

cls


--
Foodbuy
------------------------------------------------------------------------
Foodbuy's Profile: http://www.excelforum.com/member.php...o&userid=35348
View this thread: http://www.excelforum.com/showthread...hreadid=551086