CountIF formula

[Legacy 93538]

Hi

I am trying to create countif fomula which looks in a range (O24:043) and does a count of all the cells which do not contain the string 00/01/1900.

The range (O24:043) has 20 rows in it and the cells in that range are formula getting getting data from another sheet.

The count is performed without error however it retunrs 20 and it should return 12.

currently i am using

 =COUNTIF(N24:N43, "<>00/01/1900")

Does anyone know why its not returning the amount of rows without the string 00/01/1900 in it?

Thanks

Jessicaseymour

 

[balajayan]

It should be:

=COUNTIF(O24:O43, "<>0")</pre>

 

[JazzSP8]

Uhm - You say your trying to use the Column O but your formula refers to N?



If it isn't that simple then perhaps it's a formatting issue somewhere along the way? - Your formula does what it says for me with manually entered data

 

[Jonmo1]

Try

=COUNTIF(N24:N43, ">0")

 

[T. Valko]

Hi

I am trying to create countif fomula which looks in a range (O24:043) and does a count of all the cells which do not contain the string 00/01/1900.

The range (O24:043) has 20 rows in it and the cells in that range are formula getting getting data from another sheet.

The count is performed without error however it retunrs 20 and it should return 12.

currently i am using =COUNTIF(N24:N43, "<>00/01/1900")

Does anyone know why its not returning the amount of rows without the string 00/01/1900 in it?

Thanks

Jessicaseymour

You say the range is column O but your formula uses column N?

If the range contains true Excel dates then all you need to do is count cells greater than 0.

=COUNTIF(O24:O43,">0")

 

[Legacy 93538]

HI

Thanks for everyones help i used balajayan code and it seems to work perfectly!

Thank you to everyone who repesponded, you have all been a great help, i will ghave to remember that!!

Thank you