Refresher: My Excel 2000 workbook has two sheets, the first (Evaluation
Detail) contains details about course evalutions per instructor. Column A is
Course Name, B and C are Course Numbers, D is Course Date, E is Training
Provider, F is Instuctor Name, G thru P are evaluation scores and Q is
Evaluation Average.

On the second sheet (Evaluation Summary) I want to calculate the overall
course average per instructor, per month.

Although this is not exactly the solution that was suggested to me by some
very helpful peolpe (I mean that) I finally found a function which will
calculate the averages I need, and if the calculation returns a "#DIV/0!"
error, to display the cell as blank. What I now need to do is add in the
date selection component, so that evaluation averages are only calculated for
a specific month, e.g.; = 1-Sept-08 and <= 30-Sep-08. I have tried to do
this with dismal results. Can anyone help me with the correct syntax? The
following is the calculation as it currently works:

=IF(ISERROR(SUMPRODUCT(--('Evaluation Detail'!$F$7:$F$500="Linda
Sgabellone"),'Evaluation Detail'!$Q$7:$Q$500)/COUNTIF('Evaluation
Detail'!$F$7:$F$500,"Linda Sgabellone")),"",SUMPRODUCT(--('Evaluation
Detail'!$F$7:$F$500="Linda Sgabellone"),'Evaluation
Detail'!$Q$7:$Q$500)/COUNTIF('Evaluation Detail'!$F$7:$F$500,"Linda
Sgabellone"))

Thank you for all of your help - :)
--
LPS