Formula help, calculate dates and name in multiple columns

[Guest]

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.

I’ve 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 can’t seem to figure it out.

 

[Guest]

Look at the COUNTIF function.

Dave