Set logic aside.

=SUM(A$5:A65536)

will never fail you. (unless you are using Excel 2007)
--
Gary''s Student - gsnu200742


"Rich D" wrote:

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