Age range
 

Morning,

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

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

Cheers :confused:


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=506275

Age range
 

Try this:

=SUMPRODUCT(--(P1:P100=18),--(P1:P100<=21))

HTH,
Elkar


"Clash" wrote:


Morning,

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

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

Cheers :confused:


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=506275

Age range
 

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)

"Clash" wrote in
message ...

Morning,

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

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

Cheers :confused:


--
Clash
------------------------------------------------------------------------
Clash's Profile:
http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=506275

Age range
 

cheers both,

will try both.


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=506275