Age range

C

Clash

Morning,

Can anyone help me, I'm trying to count the number of 18-21 y.o. on
spreadsheet.

my spreadsheet has in column P, the age of each contact. So i'm tryin
to determine each of the age bands 18-21, 21-25 & 26+, is this a simpl
formula or something else.

Cheers :confused
 
B

Bob Phillips

Your ranges overlap, "1 is in the first and the second, but something like

=COUNTIF(P:p,">=18")-COUNTIF(P:p,">21")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top