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.

 

[Fluff]

Hi & welcome to MrExcel.
Check that calculation is set to automatic, on the formula tab under Calculation Options

 

[Schlongosaur]

Hi & welcome to MrExcel.
Check that calculation is set to automatic, on the formula tab under Calculation Options

It is indeed set to automatic throughout the sheet, this was one of the answers I found after a google around but no joy.

 

[Fluff]

When you say

click the data field

are you clicking on the cell with the formula?

 

[Schlongosaur]

When you say

are you clicking on the cell with the formula?

Nope, the cell with the info in which the formula should be picking up.

 

[Fluff]

Is that cell text or a number?

 

[Schlongosaur]

Is that cell text or a number?

It is a time in the format of hh:mm:ss

The majority of the cells are being picked up by the formula, I can see no pattern to those which it doesn't pick up

 

[Fluff]

In that case the cells that are not being picked up are probably text & not numeric.

 

[Schlongosaur]

In that case the cells that are not being picked up are probably text & not numeric.

If that is what is happening, could I expect to find a cell which isn't being picked up, go to format cells and see that it thinks it is in a different format?

 

[Fluff]

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