countif function??

[Guest]

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

 

[Dave R.]

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)

 

[Bob Phillips]

or

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

--

HTH

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

 

[Bob Phillips]

Don't need the &s

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

--

HTH

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

 

[Guest]

Thank you Bob, your formula worked perfect!

Don't need the &s

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

--

HTH

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