Hi!

=COUNTIF(A1:A10,"0")/COUNT(A1:A10)

Is zero a positive number?

You're Countif will exclude zero but Count will not.

Biff

-----Original Message-----

Use Countif() and count()

=COUNTIF(A1:A10,"0")/COUNT(A1:A10)

"rich" wrote in message
...
I have a column, with both positive and negative numbers.
I want to know how to have Excel count the positive
numbers and then devide by the total number of positve
and
neg. numbers. So count the number of positive numbers
(say
8) then dived that by the total of cells with numbers in
them (so the 8 positive plus the 5 neg. = 13 cells
w/numbers.) So 8/13. = 61%

thanks for any help.

rich


.