Age range

[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

 

[Guest]

Try this:

=SUMPRODUCT(--(P1100>=18),--(P1100<=21))

HTH,
Elkar

 

[Bob Phillips]

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

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Clash]

cheers both,

will try both