View Single Post
 
Old 08-09-2011, 09:30 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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)
Reply With Quote