Add up a column

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calendar Spreadsheet: Column 1 = Date, Column 2 Time of Day, Column 3 memo text field	JDJ	Microsoft Excel Discussion	0	24th May 2007 01:14 AM
Search for a column based on the column header and then past data from it to another column in another workbook	minkokiss	Microsoft Excel Programming	2	5th Apr 2007 01:12 AM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Programming	2	30th Dec 2006 06:23 PM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Misc	0	27th Dec 2006 04:31 PM
How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C	genesisoxygen@gmail.com	Microsoft Excel Programming	4	2nd Aug 2006 01:10 AM