| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DSUM vs. SUMPRODUCT
I found out recently that the function DSUM acts the same way as SUMPRODUCT.
They both can produce the same result. I've been using SUMPRODUCT for all this times and I was wondering if there's benefit to use 1 vs. the other. Is one more optimized that the other? Any insight would help. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DSUM vs. SUMPRODUCT
I've heard that the DSum() command requires considerably less memory.
"matelot" wrote: I found out recently that the function DSUM acts the same way as SUMPRODUCT. They both can produce the same result. I've been using SUMPRODUCT for all this times and I was wondering if there's benefit to use 1 vs. the other. Is one more optimized that the other? Any insight would help. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DSUM vs. SUMPRODUCT
I did a test with large dataset to see if one is faster than the other.
SUMPRODUCT came up faster than DSUM. That might explain that SUMPRODUCT may load the entire dataset into RAM whereas DSUM fetches the record externally. "JMay" wrote: I've heard that the DSum() command requires considerably less memory. "matelot" wrote: I found out recently that the function DSUM acts the same way as SUMPRODUCT. They both can produce the same result. I've been using SUMPRODUCT for all this times and I was wondering if there's benefit to use 1 vs. the other. Is one more optimized that the other? Any insight would help. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif/Sumproduct/Dsum ? | Excel Discussion (Misc queries) | |||
| Sum with multiple conditions - sumproduct, dsum or dproduct? | Excel Discussion (Misc queries) | |||
| DSUM | Excel Discussion (Misc queries) | |||
| DSUM or SUMPRODUCT? | Excel Worksheet Functions | |||
| sumproduct vs dsum | Excel Worksheet Functions | |||
Linear Mode
