IF formula & Percentage

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

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

"Drummy" <Drummy.28wyrn_1149485101.2281@excelforum-nospam.com> wrote in
message news:Drummy.28wyrn_1149485101.2281@excelforum-nospam.com...
>
> 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
>
>
> --
> Drummy
> ------------------------------------------------------------------------
> Drummy's Profile:
> http://www.excelforum.com/member.php...o&userid=34780
> View this thread: http://www.excelforum.com/showthread...hreadid=548450
>

Hi!

> =COUNTIF(E3:E17,"f")/COUNTA(E3:E17)*100%

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

"KellTainer" <KellTainer.28wz8b_1149485701.5122@excelforum-nospam.com> wrote
in message news:KellTainer.28wz8b_1149485701.5122@excelforum-nospam.com...
>
> 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%
>
>
> --
> KellTainer
> ------------------------------------------------------------------------
> KellTainer's Profile:
> http://www.excelforum.com/member.php...o&userid=34322
> View this thread: http://www.excelforum.com/showthread...hreadid=548450
>

thx everyone
y'all have been truly helpful!
( :