IF formula & Percentage

  • Thread starter Thread starter Drummy
  • Start date Start date
D

Drummy

OK, say whats below is E3:E17 in a column on a worksheet and I wanted to
put formulas in seperate cells stating the percentage of m's and f's in
the column, what would that formula be??

f
m
m
m
m
m
m
f
f
f
f
f
m
f
m
 
=COUNTIF(A:A,"f")/COUNTA(A:A)
=COUNTIF(A:A,"m")/COUNTA(A:A)

HTH
 

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

Back
Top