We're using Excel 2003, but thanks for the response.
--
Howard


"Fred Smith" wrote:

If you're using Excel 2007, use:
=averageif(B:B,"Monday",D:D)

Regards,
Fred

"Howard" wrote in message
...
In column B, I have the days of the week. Monday may repeat 30 times,
Tuesday
35 times etc. In column D, I have the time ([mm]:ss) for each day.
How do I get the average time for Monday?

Thanks,
--
Howard

.