drag formula

F

Fiona

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
 
D

Douglas J. Steele

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.
 
Top