View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMay JMay is offline
external usenet poster
 
Posts: 468
Default 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.