Take a look at the SumIf and CountIf functions.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Cmonroe" wrote:

I am trying to create a formula that will compare an employee's hire date to
the date of a training class. If the hire date before the training class
then count that employee's clock number and if the hire date is after the
training class do not count that employee's clock number. Is there away to do
this.

Example Spreadsheet:

Hire Date Employee Clock# Training Class Date
4/15/06 Doe, John 1234 1/6/06

My goal is to create a summary sheet that determines the average of
completion for each class and for the enitre company.