| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct Dynamic Range - XL2003
I have a sumproduct formula(s) that is calculating very slowly in my
workbook. =SUMPRODUCT(((Data!$D$2:$D$10000=$E22)*(Data!$A$2: $A$10000='H-Code SS Report'!F$21)*(Data!$K$2:$K$10000))) I'd like to insert a dynamic range to improve performance, but haven't had any luck. Any suggestions would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using sumproduct in a dynamic range? | Excel Discussion (Misc queries) | |||
| Need help please-SUMPRODUCT and Dynamic Range | Excel Worksheet Functions | |||
| Sumproduct Indirect Named Dynamic Range using Offset | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Dynamic range names, multiple criteria, sumproduct | Excel Discussion (Misc queries) | |||
Threaded Mode
