Hi. I am doing some coursework for A-level and I have come across a
problem where a 0 value is represented by a #div/0! instead of the 0.0%
which I would like.
When a cell that the chart refers to is changed sometimes the div/0
shows.
There are two main formulas which I need to adjust and have tried but
to no success:
=SUMPRODUCT(--($B$30:$B$169="F"),--($D$30:$D$169="A"))/COUNT($F$30:$F$169)

and

=COUNTIF($D$30:$D$169,"A")/COUNT($F$30:$F$169)

Both these formulas are used various times to calculate a correct
percentage in certain cells in a table.

Can anyone tell me what to do with the formula to get rid of the Div/0
error and show 0/0.0%?
I would greatly appreciate any help. Thanks a lot!


--
Jimbo43
------------------------------------------------------------------------
Jimbo43's Profile: http://www.excelforum.com/member.php...o&userid=31991
View this thread: http://www.excelforum.com/showthread...hreadid=517371