#1   Report Post  
Becky
 
Posts: n/a
Default 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
  #2   Report Post  
Biff
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotal And Countif Sheryl Excel Discussion (Misc queries) 4 December 9th 04 07:18 PM
Countif - Countif maswinney Excel Worksheet Functions 3 November 15th 04 11:06 PM
countif reno Excel Worksheet Functions 5 November 5th 04 12:20 PM
Countif, Sumif, If - help! Angel160 Excel Worksheet Functions 2 November 3rd 04 05:23 PM
countif, again Liz G Excel Worksheet Functions 2 November 1st 04 11:20 PM


All times are GMT +1. The time now is 09:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"