floating counts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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))
 
Hi Bob
One way
=COUNTA(INDIRECT("A3:A"&COUNTIF($A$3:$A$1000,"<>""")))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum to recognize new rows 3
Rearranging DATA 6
Why doesn't excel count function update automatically? 1
How can my formula handle inserted rows? 3
Trailing 30 days sum calculation with excel 1
Returning nothing if formula is false 3
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
How do i count Text in the Cells, but not formulas. 3

Back
Top