sumproduct
 

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......

sumproduct
 

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

€� ezt Ã*rta:

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......

sumproduct
 

Check your other post.

wrote:

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......

--

Dave Peterson