countif help

bob · Apr 15, 2004

I have a forumula that counting the number of times the
number 5 shows up in a range =COUNTIF(N5:N505,5)

But how can i make it count anything that 5 and lower?

Andy B · Apr 15, 2004

Hi

Try this:
=COUNTIF(N5:N505,"<="&5)

Dave R. · Apr 15, 2004

=COUNTIF(N51:N505,"<="&5)

Frank Kabel · Apr 15, 2004

Hi
try
=COUNTIF(N5:N505,"<=5")

countif help

bob

Andy B

Dave R.

Frank Kabel