Exasperated!

[i8ig]

I have used the following formula in several cells and it works in all but one. =countif(F:F,"Thompson") When I use it as: =countif(F:F,"Rowell") a 0 value is returned even tho when I look at the Function Argument box, this is what I see:

Range: F:F =F:F
Criteria: "Rowell" ="Rowell"

= 9
Counts the number of cells within a rang that meet the given condition.

Range is the range of cells from which you want to count nonblank cells


Formula results = 9

Any idea why it displays 0 instead of 9 in the target cell?

 

[Oaktree]

What happens if you select COUNTIF(F:F,"Rowell") in the formula bar and press F9? Do you get 0 or 9?

If it shows 9, you probably just have calculation set to manual (tools --> options --> calculation).

If it shows 0, maybe you misspelled (or have a leading or trailing space in) "Rowell" in the formula?

 

[i8ig]

I'll check both out

 

[Domski]

Hi,

Possibly calculation is set to manual.

Have a look at tools...options...calculation and make sure it's set to automatic.

Dom

 

[i8ig]

If I enter it in the formula bar and press F9 the correct result is displayed. Checked the setting and it is on 'automatic'.
Any other suggestions?

 

[Oaktree]

Try using edit --> replace to replace all = with =

 

[i8ig]

I did as suggested and the cell does reflect the correct count now, however there is no formula in the cell any longer and I really need a formula to continue to tabulate occurances as sheet is added to. Any suggestions?