Peo,

As usual, you impress me with your ability to find a solution! Perhaps
if I weren't quite so brain dead, I would have arrived at that. Still,
using Round along with =COUNTIF(O4:O413,"0")+COUNTIF(O4:O413,"<0") and
then trying futilely to actually have it work probably would have put me
in quite the mood...

I used Tools/Options/Calculation and ended up with a Zero value in the
cell that was previously driving me nuts. Yeah!!!

Thanks, again!

Mark
Boston, MA


--
LTUser54
------------------------------------------------------------------------
LTUser54's Profile: http://www.excelforum.com/member.php...o&userid=33459
View this thread: http://www.excelforum.com/showthread...hreadid=545250