setting more than one condition and multiple ranges

  • Thread starter Thread starter Sapper
  • Start date Start date
S

Sapper

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
 
Back
Top