count age ranges

[Clash]

Hi all,

can someone please help, I'm trying to count the number of 18-21, 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,">=18") which counts the 18 y.o's and above, but not each oh the age ranges.
I don't know how to get the other ages to calculate.

many thanks

[Miguel Zapico]

You may use try:
=SUMPRODUCT(--($I$3:$I$10>=18),--($I$3:$I$10<22))
Change the ranges and values as appropiate

Hope this helps,
Miguel.

"Clash" wrote:

>
> Hi all,
>
> can someone please help, I'm trying to count the number of 18-21,
> 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,">=18") which
> counts the 18 y.o's and above, but not each oh the age ranges.
> I don't know how to get the other ages to calculate.
>
> many thanks
>
>
> --
> Clash
> ------------------------------------------------------------------------
> Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
> View this thread: http://www.excelforum.com/showthread...hreadid=551400
>
>

[Arvi Laanemets]

Hi

=COUNTIF($I$3:$I$10,">=18")-COUNTIF($I$3:$I$10,"<=21")


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



"Clash" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> can someone please help, I'm trying to count the number of 18-21,
> 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,">=18") which
> counts the 18 y.o's and above, but not each oh the age ranges.
> I don't know how to get the other ages to calculate.
>
> many thanks
>
>
> --
> Clash
> ------------------------------------------------------------------------
> Clash's Profile:
> http://www.excelforum.com/member.php...o&userid=18951
> View this thread: http://www.excelforum.com/showthread...hreadid=551400
>

[Bob Phillips]

=COUNTIF($I$3:$I$10,">=18") -COUNTIF($I$3:$I$10,">21")

etc.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Clash" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> can someone please help, I'm trying to count the number of 18-21,
> 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,">=18") which
> counts the 18 y.o's and above, but not each oh the age ranges.
> I don't know how to get the other ages to calculate.
>
> many thanks
>
>
> --
> Clash
> ------------------------------------------------------------------------
> Clash's Profile:
http://www.excelforum.com/member.php...o&userid=18951
> View this thread: http://www.excelforum.com/showthread...hreadid=551400
>

[Arvi Laanemets]

Hi

=COUNTIF($I$3:$I$10,">=18")-COUNTIF($I$3:$I$10,"<=21")


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



"Clash" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> can someone please help, I'm trying to count the number of 18-21,
> 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,">=18") which
> counts the 18 y.o's and above, but not each oh the age ranges.
> I don't know how to get the other ages to calculate.
>
> many thanks
>
>
> --
> Clash
> ------------------------------------------------------------------------
> Clash's Profile:
> http://www.excelforum.com/member.php...o&userid=18951
> View this thread: http://www.excelforum.com/showthread...hreadid=551400
>

[Bob Phillips]

=COUNTIF($I$3:$I$10,">=18") -COUNTIF($I$3:$I$10,">21")

etc.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Clash" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> can someone please help, I'm trying to count the number of 18-21,
> 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,">=18") which
> counts the 18 y.o's and above, but not each oh the age ranges.
> I don't know how to get the other ages to calculate.
>
> many thanks
>
>
> --
> Clash
> ------------------------------------------------------------------------
> Clash's Profile:
http://www.excelforum.com/member.php...o&userid=18951
> View this thread: http://www.excelforum.com/showthread...hreadid=551400
>

[Arvi Laanemets]

Hi

=COUNTIF($I$3:$I$10,">=18")-COUNTIF($I$3:$I$10,"<=21")


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



"Clash" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> can someone please help, I'm trying to count the number of 18-21,
> 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,">=18") which
> counts the 18 y.o's and above, but not each oh the age ranges.
> I don't know how to get the other ages to calculate.
>
> many thanks
>
>
> --
> Clash
> ------------------------------------------------------------------------
> Clash's Profile:
> http://www.excelforum.com/member.php...o&userid=18951
> View this thread: http://www.excelforum.com/showthread...hreadid=551400
>

[Bob Phillips]

=COUNTIF($I$3:$I$10,">=18") -COUNTIF($I$3:$I$10,">21")

etc.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Clash" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> can someone please help, I'm trying to count the number of 18-21,
> 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,">=18") which
> counts the 18 y.o's and above, but not each oh the age ranges.
> I don't know how to get the other ages to calculate.
>
> many thanks
>
>
> --
> Clash
> ------------------------------------------------------------------------
> Clash's Profile:
http://www.excelforum.com/member.php...o&userid=18951
> View this thread: http://www.excelforum.com/showthread...hreadid=551400
>