Divide by zero error
 

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

Divide by zero error
 

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

"gregmosu" wrote:


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