i am not sure but..
=countif(A1:A55,">8")-countif(A1:A55,">10")
???
i'm not sure if this will work i havent used excel in a long long while..
i'm sure it will count the # of values between 8 and 10 in the range you specified though...
EDIT: let me know if it worked