|
|
#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) 
|
|
|
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 7 32bit 
Office 2010 32bit
Threaded Mode