floating footer

  • Thread starter Thread starter Ryan Janis
  • Start date Start date
R

Ryan Janis

I have a spreadsheet that I'm always adding entries into.
Is there a way for me to add a floating "count" at the
bottom of my spreadsheet instead of the top of the
spreadsheet? I need it to automatically drop as I keep
adding records, instead of having to cut and past the
formula as I keep heading down to the bottom of the
spreadsheet. My formula goes like this: =COUNT(A:A)
 
You could have a macro that you'd run to insert the row and adjust everything.
But when I want to see things like this, I'll put the formulas in row 1, the
headers in row 2 and then select A3 and Window|freeze Panes so that the top 2
rows are always visible.

In fact, you may want to take a look at =subtotal(2,a3:a9999). It'll react to
rows being hidden by Data|Autofilter.
 
Back
Top