This should be simple....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

but... somehow I'm not seeing or remembering how to do this...

I have a column of data, M & F (male & female).
I want to be able to have a cell where there is a count of "F" and another cell with a count of "M".
---or---
to be even better, have it just tell me the percentage of "M"s and the percentage of "F"s in the list.

Got any quick and simple suggestions? I appreciate the help. I'm still learning ALOT everyday!

Thanks:
Kat
 
Hi Kat
if your data is in column A try the following:
1. Number of males: =COUNTIF(A1:A100,"M")
2. Number of females: =COUNTIF(A1:A100,"F")
3. Percentages:
=COUNTIF(A1:A100,"M")/COUNTA(A1:A100)
or
=COUNTIF(A1:A100,"F")/COUNTA(A1:A100)
format these cells as percentage
 
Hi Kat

Try this:

=COUNTIF(F8:F26,"F")/COUNTA(F8:F26)
for the percentage of "F" and and just take the above result away from 1 to
get it for "M". Format the answers as Percentage.

This assumes that the whole range has either a F or a M

Andy.

Kat said:
but... somehow I'm not seeing or remembering how to do this...

I have a column of data, M & F (male & female).
I want to be able to have a cell where there is a count of "F" and another cell with a count of "M".
---or---
to be even better, have it just tell me the percentage of "M"s and the
Click to expand...
percentage of "F"s in the list.
 
=COUNTIF(List,"F")/COUNTA(List)

format as percentage will return percentage of females

--

Regards,

Peo Sjoblom


Kat said:
but... somehow I'm not seeing or remembering how to do this...

I have a column of data, M & F (male & female).
I want to be able to have a cell where there is a count of "F" and another cell with a count of "M".
---or---
to be even better, have it just tell me the percentage of "M"s and the
Click to expand...
percentage of "F"s in the list.
 
Back
Top