Percentage of 1s

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=COUNTIF(A10:A25,0)/COUNT(A10:A25)

data is in A10 to A25
format is as percentage
 
sorry that gives perenage of males
for femaltes
=COUNTIF(A10:A25,1)/COUNT(A10:A25)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart from 1 Column 1
ID number to Gender 7
Countif Problem 4
Percentage in Data Labels Tab 1
Referencing the values returned by a formula 3
Male/Female notation 1
Setting multiple conditions to return a figure from multiple cells 4
How to group my student data using Excel 2

Back
Top