calculating percentages

**zuwanda** · 02-02-2012, 11:50 PM

Hi,

I have data structured like below, but with thousands of rows, and would like to find percentages of females (from column B) in each group (column A).

Any ideas on how to go about this?

Col A Col B
1 M
1 F
1 F
2 M
2 M
2 M
3 F
4 M
4 M
4 M

thanks!

**JapanDave** · 02-03-2012, 01:36 AM

I am not sure if I understand correctly, but how about this?

=COUNTIF(B:B,"m")/COUNTA(B:B)

**bebo021999** · 02-03-2012, 01:39 AM

Give a try:

Untitled.jpg

**zuwanda** · 02-07-2012, 09:45 PM

JapanDave, I don't think I explained myself well, but have it figured out now. Thanks for all the helpful links, and I'll try to be more clear in future posts!