HELP ON IF

B

Becky

I need help. In column A I have a 1=male and 2=female. In column E I have
1=less than 5 yrs, 2=2-5yrs and 3=over 5 yrs. I'm trying to figure out how
many males (1's) have less than 5 yrs (1), 2-5 yrs(2), ect. I've tried the
countif but I keep getting an error. Either that or I get the wrong answer
when I test a couple of cells-help.

Thanks,
Becky
 
B

Becky

Wow, thanks. Maybe the problem before was that I was trying to use "1" (with
quotation marks).
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

countif 1
Mail Merge Help 1
List all tables, including document structure 0
Need some PWA help 0
Need Help with IF Function 1
IF/COUNTIF 2
Goal Seeking via Excel 0
If, then 1

Top