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"))

You need to change the logic since you are not using AND functionality

=COUNTIF(O34:O45,"0")-(COUNTIF(O34:O45,"=8"))



this is uses AND functionality and will give the same result


=SUMPRODUCT(--(O34:O450),--(O34:O45<8))



--

Regards,

Peo Sjoblom






"KatyCoxy" wrote in message
...
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"))