=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!