Hi, I am using excel 2003
I have one column where each cell holds "male" or "female" as text. I count
each value using countif.
I want to further refine my result by reference to another range which where
each cell either has a date or is blank.
I have tried to use the AND and IF commands and nesting elements but I am
not sure of the syntax
Can anybody help?
Thank you