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 t
put formulas in seperate cells stating the percentage of m's and f's i
the column, what would that formula be??

f
m
m
m
m
m
m
f
f
f
f
f
m
f
 
Put this in the cell for percentages of f, and custom format it as a
percentage
=COUNTIF(E3:E17,"f")/COUNTA(E3:E17)*100%

likewise for m
=COUNTIF(E3:E17,"m")/COUNTA(E3:E17)*100%
 
Hi!

Try this:

F3 = F
F4 = M

G3 = formula:

=COUNTIF(E$3:E$17,F3)/COUNTA(E$3:E$17)

copy down to G4 and format both cells as PERCENTAGE

Biff
 
Hi!
=COUNTIF(E3:E17,"f")/COUNTA(E3:E17)*100%
Click to expand...

Multiplying by 100% doesn't really do anything.

If you're going to format the cell as percentage then:

=COUNTIF(E3:E17,"f")/COUNTA(E3:E17)

If you're going to keep the default GENERAL format then:

=ROUND(COUNTIF(E3:E17,"f")/COUNTA(E3:E17)*100,1)

Biff
 
You must log in or register to reply here.

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

IF formula & Percentage 1
Scrabble Value calculation for Welsh words 0
Nested if formula question 3
help with sorting 2
Excel count with 2 conditions 2
Percentages in Pivot Tables 1
How to set a cell value based on "OR" function? 3
AutoFilter Top 10 - Incorrect Answer 1

Back
Top