Thread: floating counts
View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

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