Countif

[Richard - St John Ambulance UK]

Please Help!

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


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

 

[Frank Kabel]

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

 

[Richard]

Many thanks Frank!!

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