Hi all,
please someone check my formula and say what is wrong in it:
Range("B10").Formula
="SUMPRODUCT((PI!B10:B200=1)*(PI!D10:D200='11')*( PI!H10:H200='GREEN')*(PI!L10:L200='YES')*(PI!J10:J 200=A10)*(PI!F10:F200))"
Thanks in advance
Bijan