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)
|