Thread: Add up a column
View Single Post
  #2   Report Post  
Old May 4th 10, 11:48 PM posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Add up a column

Use a formula in a different column.

For instance, if I want to add all the values in column A, I could use this
formula in B1:

=sum(a:a)



Remmy wrote:

How can I get a column of figures to add up automatically?


--

Dave Peterson