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??

thank you