Yes, your question did come up before and you got an answer. If you use a
newsreader like OE you can sort the messages by the From field to find the
thread, then follow the thread to get the answer. Otherwise you can search
the archives of the group at Google.

If your current method of accessing the group doesn't let you find the
answer, then you are probably not using a satisfactory method of accessing
the newsgroup.

In the meantime, look again at your formula and ask yourself what each half
of the formula is doing. If you are still struggling you can split the
formula in two and see what answer each half is giving, and compare it with
what you expect from your data and what you are trying to achieve. [If you
are still struggling with the logic, you might draw yourself a simple Venn
diagram of the situation?]

You could also look again at Sassy's question and the answer, and compare it
with your question.
--
David Biddulph

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