Depending on what version of Excel you're using:

=SUM(A2:A65536)
=SUM(A2:A1048576)

--
Biff
Microsoft Excel MVP


"
m wrote in message
...
sum(a:a) sums over all elements in the "a" column. Is there a way to sum
from
"a2" for instance all the way to the end of the "a" column?