sumproduct in VBA

[bijan]

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

 

[Mike H]

Hi,


Try this

Range("B10").Formula =
"=SUMPRODUCT((PI!B10:B200>=1)*(PI!D10200=11)*(PI!H10:H200=""GREEN"")*(PI!L10:L200=""YES"")*(PI!J10:J200=A10)*(PI!F10:F200))"

Mike

 

[macropod]

Hi bijan,

Try:
Range("B10").Formula =
"=SUMPRODUCT((PI!B10:B200>=1)*(PI!D10200=11)*(PI!H10:H200=""GREEN"")*(PI!L10:L200=""YES"")*(PI!J10:J200=A10)*(PI!F10:F200))"

 

[muddan madhu]

Range("B9").Formula = "=SUMPRODUCT((PI!B10:B200>=1)*(PI!D10200=11)*
(PI!H10:H200=""GREEN"")*(PI!L10:L200=""YES"")*(PI!J10:J200=A10)*
(sheet2!F10:F200))"