One way where 9999 is any number larger than possible in your column
=SUM(A5:OFFSET(A5,MATCH(9999,A:A),0))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rich D" wrote in message
...
In summing a column range...say =sum(a$5:a175). If the column is
ever-growing, continually adding to the range, how can I alter the formula
to
include the new items beyond a175? It doesn't seem logical that I should
put
in some ridiculously large number which would include a bunch of blank
cells.
--
Rich D
Armstrong Custom Homes
Redmond