Count help!

[Foz1980]

Hi All,

This should be simple but it turns out I'm the simple one as I just cant fathom what is going wrong.

So, I have a list of dates in column N and I want to count how many entries there are for any date on or after the date that is in H3.

I have used the below formula but it just brings back "0" - which I know is incorrect.

=COUNTIF(N:N,"=>H3")

Can anyone help please?

Cheers

Chris

 

[seguin85]

Chris,

=COUNTIF(N:N,">="&H3)

*edited to change to >=, thanks for spotting that

 

[steve the fish]

You need to use ">="&H3 not "=>"&H3

 

[Foz1980]

You need to use ">="&H3 not "=>"&H3

oh god, that is so obvious!
Thanks for pointing that out to me!