Assuming your formula will be in A106 to start and you always want to start
with the 3rd row:
=COUNTA(OFFSET(A106,-ROW()+3,0,ROW()-3,1))
"Bob in Granger" wrote:
My spread sheet has several colums using COUNTA. For example:
=COUNTA(A3:A105). Each week I might insert 30 or more rows that I want
included in the count. Is there an expression in the COUNTA formula that I
can use to "float" the formulas to a row just below the last row containing
data so I do not have to modify the ending row number (A105 in this example)
when new rows are inserted?
Bob
|