|
|
|
|
#1
08-09-2011, 08:39 AM
|
|||
|
|||
From a particular cell till the end of the same column
What I want is: Sum formula in A1 Sum all the values from A2 to A* (till the end of the column A) because I will add data to the column A later on, I cannot specify A2:A? How can I possibly do it in Excel? 
|
|
#2
08-09-2011, 09:30 AM
|
|||
|
|||
|
Hi
Here is the solution: =SUM(A2:A1000001) This formula will sum one million entries Whenever you add values to the column, if you have automatic calculation turned on, the formula will recalculate. If not then press F9 to calculate manually. Good luck. Tony(OTPM)
|
|
#3
08-09-2011, 03:39 PM
|
||||
|
||||
|
If you use the table feature available in Excel 2010 then your SUM formula can reference the table column, and the table column will automatically expand as you add data to the table.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Why the "Text boundaries" are not shown till the end of the page while in other file | Jamal NUMAN | Word | 4 | 03-28-2012 07:58 AM |
| How can I delete the content of a cell in column if the cell value is more than 1000? | Learner7 | Excel | 2 | 06-27-2011 05:44 AM |
 Need to search a column for a macth and return a result from a third column
|
pdfaust | Excel | 2 | 02-03-2011 03:02 PM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
| How do I reference a merged cell in a multi column & row table in MS Word ('03')? | jihanemo | Word Tables | 0 | 03-18-2009 08:33 AM |
Windows XP 
Office 2010 32bit
Hybrid Mode