Making COUNTIF update in real time

[Bishop]

How do I make countif update in real time? For example, in column A1 I have
this formula:

=COUNTIF(A2:A5,"F")

in cells A2:A5 I have

F
P
f
X

My formula returns 2 IF the data is already present. But if I change the
data to:

F
f
F
P

my formula still returns 2 UNLESS I click on the cell the formula is in and
hit enter again. Then it will recalculate. But how do I make the formula
return the answer in real time like the SUM function does?

 

[Alan]

It works OK for me, do you have Calculation set to manual? (Tools > Options

Calculation, check 'Automatic')

Regards,
Alan.

 

[Sheeloo]

Check the format of A1 containing the formula... is it formatted as TEXT?
Change it to General...

 

[Bishop]

That was the problem. Somehow my calculation got set to manual. Works fine
now. Thanks!

 

[Michael.Tarnowski]

How do I make countif update in real time? For example, in column A1 I have
this formula:

=COUNTIF(A2:A5,"F")

in cells A2:A5 I have

F
P
f
X

My formula returns 2 IF the data is already present. But if I change the
data to:

F
f
F
P

my formula still returns 2 UNLESS I click on the cell the formula is in and
hit enter again. Then it will recalculate. But how do I make the formula
return the answer in real time like the SUM function does?

Hi,
sometimes it is necessary to force Excel to "rebuild" the formula
after a change event; have a look at
http://www.excelforum.com/excel-programming/390157-functions-wont-calculate-without-f2.html

Cheers Michael