Percentage of 1s

B

Ben

I have a column that has 1s or 0s, 1 equals female, 0 equals male. I want to
know what percentage is female. Is there a function that would do that?

Thank you.
 
R

R..VENKATARAMAN

=COUNTIF(A10:A25,0)/COUNT(A10:A25)

data is in A10 to A25
format is as percentage
 
R

R..VENKATARAMAN

sorry that gives perenage of males
for femaltes
=COUNTIF(A10:A25,1)/COUNT(A10:A25)
 
G

Gizmo63

count the number of 1's and divide by the total number of 1's and 0's.

=countif(a:a,1)/(countif(a:a,1)+countif(a:a,0))

Making the second half a sum of specifically 1's and 0's allows subtotals
and other commentary to go in col A without confusing the formula.

hth

Giz
 
Top