Dynamic range
Create a Dynamic Range.
InsertNameDefine
Copy the formula below and paste into the "refers to:" dialog box.
=OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!$B:$B),1)
Adjust Sheet1 to your sheetname
Give it a name like dyno and OK
In a cell enter =SUM(dyno)
Gord Dibben MS Excel MVP
On Sat, 1 Jul 2006 12:58:23 -0500, 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?
|