T
Tmt
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
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