Formula help, calculate dates and name in multiple columns
 

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

Formula help, calculate dates and name in multiple columns
 

Look at the COUNTIF function.

Dave
--
Brevity is the soul of wit.


"TomB KY" wrote:

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