countif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi I need help. In column A I have male=1, female=2. In column E I have
less than 5 yrs=1, two-5yrs=2 and over 5 yrs=3. How do I find out how many
males have less than 5 yrs, 2-5yrs, over 5 yrs, ect. Please help. I've
tried the countif, but still get an error-it doesn't say what the error is.
Do I need to use a different formula?

Thanks,

Becky
 
Back
Top