Sorry I didn't see your apology, I apologize for telling you to check your
first post. Anyway, hopefully you will see this post


--


Regards,


Peo Sjoblom


"Peo Sjoblom" wrote in message
...
I gave you 2 perfectly fine solutions yesterday why don't you check your
original post?
Here's what I wrote

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


Note that I removed an extra parenthesis from your posted formula

--

Regards,

Peo Sjoblom


"KatyCoxy" wrote in message
...
I tried to post this message yesterday but I'm not sure if it posted,
apologies if it comes up twice.

My question relates to the countif function. I want to count the numbers
that are greater than 0 and less than 8 in one column.

The formula that I have been trying to use, and variations therin is
=COUNTIF(O34:O45,"=0")-COUNTIF(O34:O45,"<8")

This doesn't give me the right answer. I have also tried a variation of
the
answer posted to Sassy on 6/14/2007.

Any help would be greatly appreciated.