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