Does anyone know how to solve this problem I'm having.....

I type this sum in a cell =COUNTIF($A$18:$A$100, A3)
I then drag the formula down.

It only works in the other cells if I click in the cell (or F2) then out
again. It does not automatically work when dragged down.

Is this a formatting thing??

many thanks

Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.

You'd be best off reposting your question to a newsgroup related to Excel.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Fiona" <(E-Mail Removed)> wrote in message
news:2A3AA3DF-0B71-4C74-A866-(E-Mail Removed)...
> Does anyone know how to solve this problem I'm having.....
>
> I type this sum in a cell =COUNTIF($A$18:$A$100, A3)
> I then drag the formula down.
>
> It only works in the other cells if I click in the cell (or F2) then out
> again. It does not automatically work when dragged down.
>
> Is this a formatting thing??
>
> many thanks