Making COUNTIF update in real time

  • Thread starter Thread starter Bishop
  • Start date Start date
B

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?
 
Check the format of A1 containing the formula... is it formatted as TEXT?
Change it to General...
 
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?
Click to expand...

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