Divide by zero error

[gregmosu]

I have two worksheets, one containing raw data, and the other a pivot
table averaging that data. In the first sheet, I have the candidates
name in order going down the rows(1-?), in the columns(A2-?), I have 20
questions w/their scores and at the end an average of those scores. The
problem is that not everyone has taken the test, and the average cell
only shows a divide by zero error(#DIV/0!). This is screwing up the
average display in the pivot table in the next worksheet. I was told
not to get rid of the candidates that have not taken the test, so how
do I get around this? Is there someting I can add to the pivot table so
that it ignors error rows?

Thanks,
Greg

 

[Jim May]

replace your (sample) =AVERAGE(A2:A15) with
=IF(ISERR(AVERAGE(A2:A15)),0,AVERAGE(A2:A15))
Write Back if you still have problems,
Jim May