formula question

[Guest]

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!

 

[Guest]

=sumproduct(--(B2:B100>=date(2006,01,01)),--(F2:F100<>""))

 

[T. Valko]

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).