COUNTIF

[Richard - St. John Ambulance UK]

My ambulance brigade volunteers fall into 3 age groups,
up to 11 years,BADGERS, between 11 and 18, CADETS, 18 and
over ADULTS. With help of some kind people in this group
I have sorted out ADULTS and BADGERS but not CADETS. I am
trying to use the following but it appears to be wrong!

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

Thanks if you can help!

 

[Frank Kabel]

H
try
=COUNTIF(Q3:Q65,"<18") - COUNTIF(Q3:Q65,"<=11") &" Cadets"
if 11 does NOT belong to 'Cadets'
or
=COUNTIF(Q3:Q65,"<18") - COUNTIF(Q3:Q65,"<11") &" Cadets"
if 11 belongs to the 'Cadets' group

 

[Richard]

Frank, you got it!! many thanks!

-----Original Message-----
H
try
=COUNTIF(Q3:Q65,"<18") - COUNTIF(Q3:Q65,"<=11") &" Cadets"
if 11 does NOT belong to 'Cadets'
or
=COUNTIF(Q3:Q65,"<18") - COUNTIF(Q3:Q65,"<11") &" Cadets"
if 11 belongs to the 'Cadets' group


.