Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've tried everything and can't seem to get this one.
I have a lot of different rows of text that I need counted a specific way. I have written an M for a male and F for a female (there are other text values as well). I'd like to find some way to count all the M's and all the F's to see how many Males and Females I have. Then I'd like to determine the % of Males to Females. Anyway to do this all in one cell? Or is it easier to do it in separate ones? I also have number values that correspond to body parts, i.e. a 1 = Ankle, 2 = Knee, etc. So as I would like to count all the 1's to see how many Ankles I have, and count all the 2's to see how many Knees I have, etc. Thanks so much for your help, this one is really killin' me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count matching text in two columns | Excel Discussion (Misc queries) | |||
Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linking text columns with text and data columns | Excel Worksheet Functions |