Making COUNTIF update in real time
 

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?

Making COUNTIF update in real time
 

It works OK for me, do you have Calculation set to manual? (Tools Options
Calculation, check 'Automatic')
Regards,
Alan.
"Bishop" wrote in message
...
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?

Making COUNTIF update in real time
 

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


"Bishop" wrote:

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?

Making COUNTIF update in real time
 

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

"Alan" wrote:

It works OK for me, do you have Calculation set to manual? (Tools Options
Calculation, check 'Automatic')
Regards,
Alan.
"Bishop" wrote in message
...
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?

Making COUNTIF update in real time
 

On Mar 16, 10:26 pm, Bishop wrote:
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-prog...ithout-f2.html

Cheers Michael