countif function??
 

I am needing a formula that will count how many children received a certain
test score within a specific range. I was thinking to use the countif
function but how do you include ranges
For example:
Level 1 would be children who received a test score between 0-11 (so I am
looking for how many children received a score within that range)

Using excel 2002

Thanks

You can use the countif function by counting the number 0 and above, then
subtracting the count of those over 11.

=COUNTIF(A1:A10,"="&0)-COUNTIF(A1:A10,""&11)


"sbrimley" wrote in message
...
I am needing a formula that will count how many children received a
certain
test score within a specific range. I was thinking to use the countif
function but how do you include ranges
For example:
Level 1 would be children who received a test score between 0-11 (so I am
looking for how many children received a score within that range)

Using excel 2002

Thanks

or

=SUMPRODUCT(--(A1:A10=0),--(A1:A10< =11))

--

HTH

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


"Dave R." wrote in message
...
You can use the countif function by counting the number 0 and above, then
subtracting the count of those over 11.

=COUNTIF(A1:A10,"="&0)-COUNTIF(A1:A10,""&11)


"sbrimley" wrote in message
...
I am needing a formula that will count how many children received a
certain
test score within a specific range. I was thinking to use the countif
function but how do you include ranges
For example:
Level 1 would be children who received a test score between 0-11 (so I
am
looking for how many children received a score within that range)

Using excel 2002

Thanks

Don't need the &s

=COUNTIF(A1:A10,"=0")-COUNTIF(A1:A10,"11")

--

HTH

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


"Dave R." wrote in message
...
You can use the countif function by counting the number 0 and above, then
subtracting the count of those over 11.

=COUNTIF(A1:A10,"="&0)-COUNTIF(A1:A10,""&11)


"sbrimley" wrote in message
...
I am needing a formula that will count how many children received a
certain
test score within a specific range. I was thinking to use the countif
function but how do you include ranges
For example:
Level 1 would be children who received a test score between 0-11 (so I
am
looking for how many children received a score within that range)

Using excel 2002

Thanks

Thank you Bob, your formula worked perfect!

"Bob Phillips" wrote:

Don't need the &s

=COUNTIF(A1:A10,"=0")-COUNTIF(A1:A10,"11")

--

HTH

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


"Dave R." wrote in message
...
You can use the countif function by counting the number 0 and above, then
subtracting the count of those over 11.

=COUNTIF(A1:A10,"="&0)-COUNTIF(A1:A10,""&11)


"sbrimley" wrote in message
...
I am needing a formula that will count how many children received a
certain
test score within a specific range. I was thinking to use the countif
function but how do you include ranges
For example:
Level 1 would be children who received a test score between 0-11 (so I
am
looking for how many children received a score within that range)

Using excel 2002

Thanks