Using the $ in a count formula

[Guest]

I have a spreadsheet where the formula starts in A4. I have a count function
at the bottom. However, as I enter lines at the top (starting in cell A4
again), I keep losing the formula - it does not include my inserted rows at
the top. How do I write my formula to always begin with cell A4? I thought
the $ sign would do it but I must not be placing it in the right place.

 

[Bob Phillips]

$A$4

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Domenic]

Try...

=COUNT(INDEX(A:A,4):A10)

Hope this helps!