Hi,

Am Fri, 23 Nov 2012 18:30:10 -0800 (PST) schrieb naga rajan:

A1 = 00:00:05
A2 = 00:00:02
A3 = 00:00:00
A4 = 00:00:01
A5 = 00:01:00
A6 = 00:00:23
A7 = 00:00:00
A8 = 00:00:12
A9 = 00:00:00
A10 = 00:00:15

Number of zeros = 3
How to solve this.

try:
=COUNTIF(A1:A10,0)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2