Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
I'm working on a spreadsheet listing people with hire dates (column B) and
the date the individual took a particular training course (if they did take the course, a date is entered in column F). I need a formula to count the number of people with 1) a date greater than or equal to 01/01/06 in column B, and 2) any entry in column F. The goal is to see the number of people hired since 01/01/06 who have taken that training course. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
=sumproduct(--(B2:B100=date(2006,01,01)),--(F2:F100<""))
"Michele" wrote: I'm working on a spreadsheet listing people with hire dates (column B) and the date the individual took a particular training course (if they did take the course, a date is entered in column F). I need a formula to count the number of people with 1) a date greater than or equal to 01/01/06 in column B, and 2) any entry in column F. The goal is to see the number of people hired since 01/01/06 who have taken that training course. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
Try this:
any entry in column F =SUMPRODUCT(--(ISNUMBER(B1:B10)),--(B1:B10=DATE(2006,1,1)),--(F1:F10<"")) Note: you can't use entire columns as range references (unless you're using Excel 2007). -- Biff Microsoft Excel MVP "Michele" wrote in message ... I'm working on a spreadsheet listing people with hire dates (column B) and the date the individual took a particular training course (if they did take the course, a date is entered in column F). I need a formula to count the number of people with 1) a date greater than or equal to 01/01/06 in column B, and 2) any entry in column F. The goal is to see the number of people hired since 01/01/06 who have taken that training course. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question | Excel Worksheet Functions | |||
What IF - formula question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) |