Works fine for me. What is the data like?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Colchabay" wrote in message
...
It comes up 0 when I type this formula in a cell below the column.

Judy

"Bob Phillips" wrote:

=COUNTIF(A:A,"70")/COUNTA(A:A)

=COUNTIF(A:A,"Male")/COUNTA(A:A)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Colchabay" wrote in message
...
I need to know how the formula to find the percent of a column. For
example.
What percent of the numbers in column A are above 70. OR What
percent
of
column B (Gender) are Male.

Also, need to find the percent of what percent of Males (column B)
are
above 70 (column A). Refering to 2 columns?

Thanks.