View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How do I convert total amount figures in excel to the next colum

If in column B you want the total from column A, then in whichever cell you
want the result in column B, put the formula =SUM(A:A)
--
David Biddulph

"PR Pillai" wrote in message
...
How do I convert total amount figures in excel to the next colum