sumproduct in VBA

B

bijan

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:J200=A10)*(PI!F10:F200))"
Thanks in advance
Bijan
 
M

Mike H

Hi,


Try this

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

Mike
 
M

macropod

Hi bijan,

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

muddan madhu

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