Using the $ in a count formula
 

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.

Using the $ in a count formula
 

$A$4

--
HTH

Bob Phillips

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

"Kim Hawk" <Kim wrote in message
...
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.

Using the $ in a count formula
 

Try...

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

Hope this helps!

In article ,
Kim Hawk <Kim wrote:

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.