Can you sum over a range with one end fixed and the other infinite
 

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?

Can you sum over a range with one end fixed and the other infinite
 

=sum(a2:a65536)
in xl2003.

If you know you have text in A1, you can use:
=sum(a:a)

If you know that you have a number in A1:
=sum(a:a)-a1



wrote:

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?

--

Dave Peterson

Can you sum over a range with one end fixed and the other infinite
 

Hi,

=SUM(A2:A65536)
or
=SUM(A:A)-A1

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


" wrote:

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?

Can you sum over a range with one end fixed and the other infinite
 

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?