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