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

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

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

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

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