Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can i use sumproduct this way in VB?
Can i use sumproduct in VB the same way in a cell of excel. The only
difference being i am using application.worksheetfunction.sumproduct(--(Worksheets("A").Range("A2:A9") _ =Worksheets.Range("A1),--(Worksheets("A").Range("b2:b9") _ =Worksheets.Range("b1),--(Worksheets("A").Range("c2:c9")) Is that possible, or do i need to use a different method to accomplish the same task? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Help with SUMPRODUCT | Excel Worksheet Functions | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
sumproduct | Excel Discussion (Misc queries) |