| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use SUMPRODUCT in macro?
"Bob Phillips" wrote in
: Odd. Can you try this for me? ActiveCell.Formula = "=SOMMEPROD((C1:C10 = 1)*(D1:D10 = ""Ya""))" Hello, I've already try this formula. The result appear only when I edit cell with F2 and Enter (I refer cells in an another workbook who is open in the same macro). When I use FormulaR1C1Local the result appear immediately. bye |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumProduct not Working in a Macro | Excel Worksheet Functions | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| SUMPRODUCT macro | Excel Discussion (Misc queries) | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Hybrid Mode
