Hi,
I have a long column of #'s that consist of positive and negative #'s
of differing values. I am looking for a simple formula that will count
the number of #'s that are negative and divide that by the number of
values that are positive. IS there an easy way?
thanks!

Signature
RalphSE
Peo Sjoblom - 13 Jan 2006 19:45 GMT
=COUNTIF(Range,"<0")/COUNTIF(Range,">0")

Signature
Regards,
Peo Sjoblom
> Hi,
>
[quoted text clipped - 4 lines]
>
> thanks!
RalphSE - 13 Jan 2006 21:06 GMT
Thanks All!! :) ;)

Signature
RalphSE
SteveG - 13 Jan 2006 19:48 GMT
=COUNTIF(A1:A7,"<0")/COUNTIF(A1:A7,">0")
This excludes zeros.
HTH
Steve

Signature
SteveG