Try this:

=COUNTIF(A1:A10,"=1")-COUNTIF(A1:A10,"2")

Or, use cells to hold the range:

B1 = 1
C1 = 2

=COUNTIF(A1:A10,"="&B1)-COUNTIF(A1:A10,""&C1)

Biff

"AdamMCW" wrote in message
...
I have a list of scores 1.1, 3.2, 1.2, 2.4, 1.1, 3, etc... . I need to
know
how many are between 1 and 2. Is this a countif? I can't seem to figure
out
how to use two conditions.