problems with formulas

[Mike Lowe]

I am trying to create a formula to count the number of people in a table
between a set of age values (3 to 14) i have data in 3 columns for forename,
suname, age, but over 2500 entries to extract the data from..

Please can you help

Mike

[daddylonglegs]

Try this

=COUNTIF(C:C,">2")-COUNTIF(C:C,">14")

[Don Guillett]

try something like
=sumproduct((agerange>=3)*(agerange<=14))

--
Don Guillett
SalesAid Software
[email protected]
"Mike Lowe" <Mike [email protected]> wrote in message
news:[email protected]...
>I am trying to create a formula to count the number of people in a table
> between a set of age values (3 to 14) i have data in 3 columns for
> forename,
> suname, age, but over 2500 entries to extract the data from..
>
> Please can you help
>
> Mike

[Gary''s Student]

Let's say the ages are column G. Try:

=COUNTIF(G:G,"<15")-COUNTIF(G:G,"<3")

This will exclude 2 and under.
This will exclude 15 and over.
--
Gary's Student


"Mike Lowe" wrote:

> I am trying to create a formula to count the number of people in a table
> between a set of age values (3 to 14) i have data in 3 columns for forename,
> suname, age, but over 2500 entries to extract the data from..
>
> Please can you help
>
> Mike

[Mike Lowe]

Thanks for that
Mike

"Gary''s Student" wrote:

> Let's say the ages are column G. Try:
>
> =COUNTIF(G:G,"<15")-COUNTIF(G:G,"<3")
>
> This will exclude 2 and under.
> This will exclude 15 and over.
> --
> Gary's Student
>
>
> "Mike Lowe" wrote:
>
> > I am trying to create a formula to count the number of people in a table
> > between a set of age values (3 to 14) i have data in 3 columns for forename,
> > suname, age, but over 2500 entries to extract the data from..
> >
> > Please can you help
> >
> > Mike

[Mike Lowe]

Thanks
Mike

"Don Guillett" wrote:

> try something like
> =sumproduct((agerange>=3)*(agerange<=14))
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Mike Lowe" <Mike [email protected]> wrote in message
> news:[email protected]...
> >I am trying to create a formula to count the number of people in a table
> > between a set of age values (3 to 14) i have data in 3 columns for
> > forename,
> > suname, age, but over 2500 entries to extract the data from..
> >
> > Please can you help
> >
> > Mike
>
>
>

[Mike Lowe]

Cheers for that, its perfect

"daddylonglegs" wrote:

>
> Try this
>
> =COUNTIF(C:C,">2")-COUNTIF(C:C,">14")
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=514946
>
>