My question is similar to the one posted by Sassy on 6/14/07 (sorry I forgot
to check which discussion group I was looking at...)

I want to find out, in the same column, the numbers that are greater than 0
but less than 8

Following the example given in response to Sassy's question, I still get the
wrong answer (there are small amounts of numbers so I can check easily)

This is the formula I tried:
=COUNTIF(O34:O45,"0")-(COUNTIF(O34:O45,"<8"))