Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct in VBA
The error i get is type mismatch for this sumproduct function in VBA:
r = WorksheetFunction.SumProduct((Left(Range("I1:I31") , 3) = "XCH"), (Range("J1:J31"))) same happen if i put array in. Do you have any idea? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct in VBA
Try
r=Evaluate("=SumProduct(--(Left(I1:I31, 3)=""XCH""),J1:J31)") -- HTH RP (remove nothere from the email address if mailing direct) wrote in message oups.com... The error i get is type mismatch for this sumproduct function in VBA: r = WorksheetFunction.SumProduct((Left(Range("I1:I31") , 3) = "XCH"), (Range("J1:J31"))) same happen if i put array in. Do you have any idea? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
SumProduct | Excel Worksheet Functions | |||
Sumproduct Help | Excel Worksheet Functions | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions |