Text into Numeric values?

[levtweeney]

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|
+-------------------------------------------------------------------+

 

[Per Jessen]

Hi

CountIf is what you need:

=COUNTIF(A1:A10;"Male")

Regards,
Per

 

[Mike H]

try

=COUNTIF(A1:A20,"Male")

with the obvious change for female

Mike

 

[Shane Devenshire]

Hi,

=COUNTIF(A1:A100,"Female")
=COUNTIF(A1:A100,"Male")

adjust the range to match yours.

 

[Simon Lloyd]

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)