Counting + and - Values

[RalphSE]

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!

 

[Peo Sjoblom]

=COUNTIF(Range,"<0")/COUNTIF(Range,">0")

 

[SteveG]

=COUNTIF(A1:A7,"<0")/COUNTIF(A1:A7,">0")

This excludes zeros.

HTH

Steve

 

[RalphSE]

Thanks All!!