It is self adjusting using match to find any number greater than possible in
your column. As you add/delete rows it will adjust the sum accordingly.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dr Teeth" wrote in message
...
On Wed, 2 Jan 2008 17:36:23 -0600, "Don Guillett"
wrote:

=SUM(A2:OFFSET(A2,MATCH(999999,A:A,1),1))

Can you explain how that works? That way this newuser would be able to
learn how the command works and not have to ask again for a different
range.

Cheers,

Guy

** Stress - the condition brought about by having to
** resist the temptation to beat the living daylights
** out of someone who richly deserves it.