there will be NO zero's. but a cell could be blank. i
dont want it counted then.

thanks again.


-----Original Message-----
P.S.

In other words, how does the poster want to handle zeros,
if any?

Biff

-----Original Message-----
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


.

.

.