| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using SUMPRODUCT with arrays
I am using a workbook that has two sheets. One is a data sheet the other is a
reporting template. On the reporting template sheet I am using about 25 sumproduct functions like the one below. This seems to take some time to calculate. Is there a faster way of running these formulas. I know the issue is not the PC. =SUMPRODUCT(--(DATA!$B$2:$B$61523=$C$5),--(DATA!$C$2:$C$61523=$C$6),--(DATA!$D$2:$D$61523="Strongly Agree")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT with 3 arrays not working | Excel Worksheet Functions | |||
| Sumproduct arrays | Excel Discussion (Misc queries) | |||
| Problem with SUMPRODUCT and Arrays | Excel Worksheet Functions | |||
| sumproduct, arrays affecting speed | Excel Worksheet Functions | |||
| If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
Threaded Mode
