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


--
Drummy
------------------------------------------------------------------------
Drummy's Profile: http://www.excelforum.com/member.php...o&userid=34780
View this thread: http://www.excelforum.com/showthread...hreadid=548450

IF formula & Percentage
 

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

IF formula & Percentage
 

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" wrote in
message ...

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

IF formula & Percentage
 

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" wrote
in message ...

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

IF formula & Percentage
 

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


--
Drummy
------------------------------------------------------------------------
Drummy's Profile: http://www.excelforum.com/member.php...o&userid=34780
View this thread: http://www.excelforum.com/showthread...hreadid=548450