sumproduct

[fi.or.jp.de]

Hi,

I have formula =SUMPRODUCT(--(B3=Sheet2!A:A),--(D3=Sheet2!B:B))

how should use same formula in using VBA like
appllication.worksheetfunction.sumproduct......

 

[Stefi]

x = WorksheetFunction.SumProduct(--(Range("B3") =
Worksheets("Sheet2").Range("A:A")), --(Range("D3") =
Worksheets("Sheet2").Range("B:B")))

I suppose you use Excel2007, because there are whole column references (A:A)
in your formula.

Regards,
Stefi

„[email protected]†ezt írta:

 

[Dave Peterson]

Check your other post.

Hi,

I have formula =SUMPRODUCT(--(B3=Sheet2!A:A),--(D3=Sheet2!B:B))

how should use same formula in using VBA like
appllication.worksheetfunction.sumproduct......