View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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.