Using the $ in a count formula

K

Kim Hawk

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.
 
B

Bob Phillips

$A$4

--
HTH

Bob Phillips

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