Hello,

I've used this formular to find work piece that gets done per department.
=SUMPRODUCT(('Q2'!E13:E150="Done")*('Q2'!G13:G150= "14532"))

Department 14532 was not picked up even though other department's number was
correctly counted. But if I put a letter, say like C (14532C) and adds C to
my formular as in
=SUMPRODUCT(('Q2'!E13:E150="Done")*('Q2'!G13:G150= "14532C")) then it picks
up how many pieces were done for this department.

I suspect this is in my cell format but I could not figure out what went
wrong. Please help. Thanks.

Tmt