drag formula
 

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

drag formula
 

Hi,

Try,

Tools|Options|Calculation tab

Set calculation to automatic.

Mike

"Fiona" wrote:

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

drag formula
 

thank you mike, it was on automatic, but i switched it to manual then back to
automatic and it works so must have been something to do with that

thanks!

"Mike H" wrote:

Hi,

Try,

Tools|Options|Calculation tab

Set calculation to automatic.

Mike

"Fiona" wrote:

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