Can you figure out a MS Excel formula for me?



I want to calculate the total number of tests in our log referenced in three
columns but under specific criteria.

Ive searched MS help without success. I essentially want a formula that
counts the data in columns C and D (cell filled with a date), only if the
name €œDoe€� appears in column E. I understand that dates are referred as
serial numbers by excel, but I still cant seem to figure it out.

--
Tom B