Countif to always get a positive number

From: OrlandoFreeman <OrlandoFreeman_at_discussions.microsoft.com>
Date: Sat, 1 Jul 2006 06:58:01 -0700

I want to countif the occurrences between a certain average result/number in my cell V66 and cero. Because my data would be changing over time, the numbers of occurences will be higher or lower. How do I combine the following to countif and always get a positive number?:

• If I use my formulae =COUNTIF(V5:V64,">"&V66)-COUNTIF(V5:V64,">0"), I get the correct number, but it is a negative number (e.g.-25)
• If I reverse the order in the formulae above:

=COUNTIF(V5:V64,">0")-COUNTIF(V5:V64,">"&V66), I still get the correct number and it is positive (e.g. 25).

Thank you Received on Sat Jul 01 2006 - 06:58:01 PDT