COUNTIF function error - missing data until I go in and out of field is is 'counting'

[Schlongosaur]

I am a massive novice when it comes to Excel however cannot work out what is happening here...

Am using a very simple COUNTIF function however this function is missing data which it only then picks up if I click the data field, go into the formula bar and hit enter.
I am not changing anything in the formula bar so see no reason why this should make a difference?

Please do shout if there is any more information needed to help you help me in any way at all with this.

 

[Schlongosaur]

The cell format is irrelevant as it doesn't affect what is actually in the cell. How are those cells being populated?

Entered manually at first (using the fill handle to save time) and then copy/pasted where there were blocks which were identical.

 

[Fluff]

In that case it sounds as though someone has entered the values incorrectly. You can use the text to columns on the data tab to convert the column to numbers.

 

[Schlongosaur]

In that case it sounds as though someone has entered the values incorrectly. You can use the text to columns on the data tab to convert the column to numbers.

You are a wizard! That has sorted it.

I entered the data myself, not sure how I would have entered some of the values as numbers and others not? But all solved now so thank you very much.

 

[Fluff]

Glad it's sorted & thanks for the feedback.