countif

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP ON IF 2
Access Counting records based on multiple age bracket and output to tabulated report 0
IF/COUNTIF 3
Calculate duration (#yrs., # mos.) 2
Need Help with IF Function 1
Repaymen of loan excel sheet with grace period etc... 14
At least two males 1
Multiple Table Query 4

Top