Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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...... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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...... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | New Users to Excel | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct #value! | Excel Worksheet Functions | |||
sumproduct ? | Excel Worksheet Functions |