Try using

=COUNTIF(G4:M4,"<0")

where g to m are the column you are lookin for zero values in.


Ruth


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=383851