countif
 

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

see your previous post!

Biff

-----Original Message-----
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
.