Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions | |||
countif | Excel Worksheet Functions | |||
Countif, Sumif, If - help! | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |