Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text into Numeric values?
Hi All Bg:) I have a column that has either "Male" or "Female" text populating the cells. Is there a formula that can count all "Male" cells and give me a final total for males and final total for females? Please see attached file Many thanks Kevin +-------------------------------------------------------------------+ |Filename: Gender.xls | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=175| +-------------------------------------------------------------------+ -- levtweeney ------------------------------------------------------------------------ levtweeney's Profile: http://www.thecodecage.com/forumz/member.php?userid=478 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113915 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text into Numeric values?
Hi
CountIf is what you need: =COUNTIF(A1:A10;"Male") Regards, Per "levtweeney" skrev i meddelelsen ... Hi All Bg:) I have a column that has either "Male" or "Female" text populating the cells. Is there a formula that can count all "Male" cells and give me a final total for males and final total for females? Please see attached file Many thanks Kevin +-------------------------------------------------------------------+ |Filename: Gender.xls | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=175| +-------------------------------------------------------------------+ -- levtweeney ------------------------------------------------------------------------ levtweeney's Profile: http://www.thecodecage.com/forumz/member.php?userid=478 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113915 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text into Numeric values?
try
=COUNTIF(A1:A20,"Male") with the obvious change for female Mike "levtweeney" wrote: Hi All Bg:) I have a column that has either "Male" or "Female" text populating the cells. Is there a formula that can count all "Male" cells and give me a final total for males and final total for females? Please see attached file Many thanks Kevin +-------------------------------------------------------------------+ |Filename: Gender.xls | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=175| +-------------------------------------------------------------------+ -- levtweeney ------------------------------------------------------------------------ levtweeney's Profile: http://www.thecodecage.com/forumz/member.php?userid=478 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113915 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text into Numeric values?
Hi,
=COUNTIF(A1:A100,"Female") =COUNTIF(A1:A100,"Male") adjust the range to match yours. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "levtweeney" wrote: Hi All Bg:) I have a column that has either "Male" or "Female" text populating the cells. Is there a formula that can count all "Male" cells and give me a final total for males and final total for females? Please see attached file Many thanks Kevin +-------------------------------------------------------------------+ |Filename: Gender.xls | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=175| +-------------------------------------------------------------------+ -- levtweeney ------------------------------------------------------------------------ levtweeney's Profile: http://www.thecodecage.com/forumz/member.php?userid=478 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113915 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text into Numeric values?
levtweeney;408817 Wrote: Hi All Bg:) I have a column that has either "Male" or "Female" text populating the cells. Is there a formula that can count all "Male" cells and give me a final total for males and final total for females? Please see attached file Many thanks KevinIf you want them on the same line: ="Males: " & COUNTIF(A1:A20,"Male") & " Females:" & COUNTIF(A1:A20,"Female") of course change your range for your actual range -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113915 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Numeric values to Text | Excel Worksheet Functions | |||
Extrapolate numeric values from text string | Excel Worksheet Functions | |||
Assigning text values to numeric fields | Excel Discussion (Misc queries) | |||
Text values to numeric values | Excel Discussion (Misc queries) | |||
Sort text Values in Numeric Order | Excel Discussion (Misc queries) |