Countif

Richard - St John Ambulance UK · Jul 21, 2004

Please Help!

I want the following to disregard people of 10 or younger
as they are "Badgers"

=COUNTIF(Q3:Q65,"<18")&" Cadets"

Frank Kabel · Jul 21, 2004

Hi
one way:
=COUNTIF(Q3:Q65,"<18") - COUNTIF(Q3:Q65,"<=10") &" Cadets"

Richard · Jul 21, 2004

Many thanks Frank!!

-----Original Message-----
Hi
one way:
=COUNTIF(Q3:Q65,"<18") - COUNTIF(Q3:Q65,"<=10") &" Cadets"
.