Since you said that you *didn't* want to see a zero, as well as a #DIV/0
error, try this:
=IF(COUNTIF(E57:GB57,"u"),COUNTIF(E57:GB57,"u")/COUNTA(E57:GB57)*100,"")
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mevetts" wrote in
message ...
Hi,
I'm using this formula -
=COUNTIF(Registers!E57:GB57,"ü")/COUNTA(Registers!E57:GB57)*100
Is there a way of developing it so that if there is no data to be
calculated or if the answer is 0 then the cell is left blank. At the
moment it displays #DIV/0!
Cheers,
Mark.
--
mevetts
------------------------------------------------------------------------
mevetts's Profile:
http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=499203