Remember Me?

#1
May 4th 10, 11:08 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Sep 2009 Posts: 2

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

#2
May 4th 10, 11:48 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 35,218

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
#3
May 5th 10, 12:15 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 9,221

In say, B1: =SUM(A:A)
would achieve your objective to do it for col A
voila? hit the YES below
--
Max
Singapore
---
"Remmy" wrote:
How can I get a column of figures to add up automatically?

#4
July 2nd 21, 08:45 AM
 Member First recorded activity by ExcelBanter: Jun 2021 Posts: 47
SUM Function in Excel!

Hello! I don't think you can add a column without doing anything, but you can put a formula that can do a SUM of the whole Column, depending on what kind of SUM you want.

This can be done via the SUM Functions in Excel.

So to simply sum a whole column, you just:

=sum(A:A)

you just put this in a different column to prevent a looping of the formula, which will cause an error. Hope this helps!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post TVGuy29 Excel Discussion (Misc queries) 1 January 24th 08 10:50 PM jeannie v Excel Worksheet Functions 4 December 13th 07 08:36 PM [email protected] Excel Discussion (Misc queries) 1 December 27th 06 06:47 PM James New Users to Excel 1 November 10th 06 12:59 AM jenniss Excel Discussion (Misc queries) 5 January 6th 05 09:18 PM

All times are GMT +1. The time now is 12:13 AM.