Try this on sheet 2

=SUMPRODUCT((Sheet1!A1:A5="F001")*(Sheet1!B1:B5=0) )

Mike

"deen" wrote:

Hi,

In Sheet1, data i have

A B
EMPCODE AMT

F001 2
F001 3
F001 0
F001 0


WITH USE OF THIS DATA I REQUIRED RESULT IN SHEET2 , COUNT OF ZERO IN
SHEET2

SHEET 2
A B
EMPCODE COUNT OF ZERO

F001 2


REGARDS,

DEEN