Hi sheelo

Thanks for help. Using your first example I get an error message, using the
second I get a "value" message.
What is the significance of the dashes(--) in the formula?
What is the significance of using A3 instead of "Female" in the second
formula?
I clearly have a lot to learn but my books dont go deep enough into subject.

Sapper

"Sapper" wrote: my

Hi,
A B
1 Male
2 Male 21/06/71
3 Female 08/11/68 #
4 Male 11/04/70
5 Female
6 Female 19/10/69 #

I want to count the number of females in A with a date against their name in
B and return as a number.
=Countif(A1:A6,"Female") returns 3. How can I tell excel to look at those 3
cells(without knowing their references) and count those with a date in the
adjacent cell ie 2?

Thank you