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


--
gregmosu
------------------------------------------------------------------------
gregmosu's Profile: http://www.excelforum.com/member.php...o&userid=35950
View this thread: http://www.excelforum.com/showthread...hreadid=557361