1) What percentage of numbers in A are greater than 70:
=COUNTIF(A:A,"70")/COUNT(A:A) and format the cell with %,
or =100*COUNTIF(A:A,"70")/COUNT(A:A)
If you mean 70 or more (i.e 70 is be counted)
=COUNTIF(A:A,"=70")/COUNT(A:A)
If you have a definite range for the numbers
=COUNTIF(A5:A105,"70")/COUNT(A5:A105)
2) Gender
=COUNTIF(B:B,"M")/COUNTA(B:B) (do note the A in CountA here)
3) combined, what percentage of the Males are over 70
=SUMPRODUCT(--(A1:A6553670),--(B1:B65536="M"))/COUNTIF(B1:B65536,"M")
What percentage of all entries are Males over 70
=SUMPRODUCT(--(A1:A6553670),--(B1:B65536="M"))/COUNT(A1:A65536)
Cannot use entire column (A:A) with Sumproduct
For info on SUMPRODUCT see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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.