sumproduct in VBA
 

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

sumproduct in VBA
 

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

"bijan" wrote:

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

sumproduct in VBA
 

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))"

--
Cheers
macropod
[MVP - Microsoft Word]


"bijan" wrote in message ...
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

sumproduct in VBA
 

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))"


On Nov 23, 3:56*pm, bijan wrote:
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