countif for 0
 

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

countif for 0
 

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

countif for 0
 

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









On Sep 7, 2:46 pm, Mike H wrote:
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 ,COUNTOF ZERO IN
SHEET2

SHEET 2
A B
EMPCODE COUNTOF ZERO

F001 2

REGARDS,

DEEN

countif for 0
 

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

"deen" wrote:

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









On Sep 7, 2:46 pm, Mike H wrote:
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 ,COUNTOF ZERO IN
SHEET2

SHEET 2
A B
EMPCODE COUNTOF ZERO

F001 2

REGARDS,

DEEN