IF formula & Percentage

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
 
K

KellTainer

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%
 
B

Biff

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
 
B

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
 
Top