Divide by zero error

G

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averages excluding zeros 3
Average time 1
Exlude Zero Values from Average 2
Finding matching fields accross multiple worksheets 2
Ignore zero in column for subtotal 3
return a zero for error 9
Divide by zero error 3
hiding zero for a sum 3

Top