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