| 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 | |||
Hybrid Mode
