Hi Claus,

It worked.
Thanks for the help.
Am having another problem.
Consider a column A1 to A10.
Its formatted in time.
I want to count only the number of zeros (00:00:00) appearing in that column.

The below example:

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.

Regards,
Naga