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), Column A is Instructor Name,
Column B is the date in MMM-YY format, C is number of courses, D is number of
evaluations and E is Evaluation Average. In column E I want to calculate
the evaluation average per instructor, per month.

I have tried the following calculation but it does not return anything. I
have looked at it until my eyes are crossed but I cannot find why it is not
working. I think something is missing but... what???

Can anyone shed some much needed light on this? I appreciate all suggestions.

=IF(ISERROR(SUMPRODUCT(--('Evaluation
Detail'!$F$7:$F$500=A7),--(TEXT('Evaluation
Detail'!D$7:D$500,"mmm-yy")=TEXT(B1,"mmm-yy")),'Evaluation
Detail'!$Q$7:$Q$500)/SUMPRODUCT(--('Evaluation
Detail'!$F$7:$F$500=A7),--(TEXT('Evaluation
Detail'!D$7:D$500,"mmm-yy")=TEXT(B1,"mmm-yy")))),"",SUMPRODUCT(--('Evaluation
Detail'!$F$7:$F$500=A7),--(TEXT('Evaluation
Detail'!D$7:D$500,"mmm-yy")=TEXT(B1,"mmm-yy")),'Evaluation
Detail'!$Q$7:$Q$500)/SUMPRODUCT(--('Evaluation
Detail'!$F$7:$F$500=A7),--(TEXT('Evaluation
Detail'!D$7:D$500,"mmm-yy")=TEXT(B1,"mmm-yy"))))
--
LPS