countif for 0

[deen]

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

 

[Mike H]

Try this on sheet 2

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

Mike

 

[deen]

Hi Mike,

Thx a Lot , Its working fine,

and 1 more doubt can you pls guide me how to use vlookupif condition.

kindly explain with eg.

Regards,

Deen

 

[Mike H]

Deen,

Thanks for the feedback. I assume you mean Vlookup and not vlookupif which
I've never heard of. Have a look here for and explanation and implementation
of vlookup.

http://www.contextures.com/xlFunctions02.html

Mike