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