floating counts
 

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

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

Hi Bob
One way
=COUNTA(INDIRECT("A3:A"&COUNTIF($A$3:$A$1000,"<"" ")))

--
Regards
Roger Govier
"Bob in Granger" <Bob in wrote in message
...
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