it sounds like you have a =daverage(a,b,c) formaul entered on yo
worksheet. if so, change this to =if(count(range with qualifie
employees)=0,0,daverage(a,b,c)

--
duan
-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=26789