79290350

Date: 2024-12-18 08:02:43
Score: 3.5
Natty:
Report link

I have tried this formula and it works

=SUMPRODUCT(('Stop Work'!$D$8:$D$500=$C10)('Stop Work'!$K$8:$K$500="Open")('Stop Work'!$C$8:$C$500=$B$2))

thank you anyway

Reasons:
  • Blacklisted phrase (0.5): thank you
  • Low length (1):
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Ramadan Moussa