Countif to always get a positive number
 

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

Countif to always get a positive number
 

Nel post
*OrlandoFreeman* ha scritto:

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


Don't multipost.

I answered your question on microsoft.public.excel.worksheet.function


--
Ciao

Franz Verga from Italy

Countif to always get a positive number
 

I'm not quite sure what you're doing, but if you surround your formula with
=abs(), you'll end up with a non-negative result.

=abs(countif(...)-countif(...))



OrlandoFreeman wrote:

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

--

Dave Peterson