| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SumProduct in VBA
Hi,
XL2003 I have the following Code: Do Until Sheets("Sheet2").Cells(A, 4) = "" B = Sheets("Sheet2").Cells(A, 4) Sheets("Sheet2").Cells(A, 6) = Evaluate("=SUMPRODUCT(--(Sheet1!C3:C100 = B) * (Sheet1!E3:E100))") A = A + 1 Loop In the Evaluate("Sumproduct... line, B is a variable, but it's not being read. Can I use a variable in the above line? Thanks in advance. Dave. |
| 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 | |||
Threaded Mode
