Thread
:
Using the $ in a count formula
View Single Post
#
2
Posted to microsoft.public.excel.misc
Bob Phillips
Posts: n/a
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.
Reply With Quote