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!

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!

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!