How about just using a row number that's bigger than you'll ever need:

=sum(b3:b9999)
or even
=sub(b3:b65536)

And if you don't have numbers in B1:B2, you can just use:
=sum(b:b)

or if you have numbers:
=sum(b:b)-sum(b1:b2)



pelachrum wrote:

I need to add up numbers in a column, my column will have a dynamic
height though. The range now for instance is B3-B12, next month it
could be B3-B23 and so on. The very bottom field in that column will
sum up the above values but again that field will have to move down as
the column grows

Siggestions?

--
pelachrum
------------------------------------------------------------------------
pelachrum's Profile: http://www.excelforum.com/member.php...o&userid=35962
View this thread: http://www.excelforum.com/showthread...hreadid=557594

--

Dave Peterson