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

[jimbeau_holland]

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]

=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

 

[Shane Devenshire]

Hi,

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

 

[T. Valko]

Depending on what version of Excel you're using:

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

--
Biff
Microsoft Excel MVP


"(e-mail address removed)"