If I didn't put a letter behind my data, the sumproduct counted as zero,
nothing picked up.

Please help. Thanks.

"Tmt" wrote:

Hello,

I need help solving this formula:
=SUMPRODUCT(('Q2'!E13:E150="done")*('Q2'!G13:G150= "14521"))

where the numbers of "done" items is counted under department 14521. This
formula works with many departments but skipped department# 14521. But if I
put a letter, say like 14521S, in my Q2 datasheet and changed this formula to
=SUMPRODUCT(('Q2'!E13:E150="done")*('Q2'!G13:G150= "14521S"))
then the formula worked again, counting every one that I added the S behind
those data.

I suspected the cell format and try to format the cells Catergory to
"General", but that didn't help.

What's wrong? Please help. Thanks.

Tmt