sumproduct vs dsum
 

RIght now in my workbook, I have several hundred SUMPRODUCT formulas.
This causes workbook calculatin to be extremly slow. Would DSUM
function help speed this up? I am very familiar with this function,
but have not used it in many places at once. I don't want to replace
SUMPRODUCT unless it will give me a noticable increase in calc speed.
Please let me know your opinion on this. Thanks a lot

JKC


--
JKC
------------------------------------------------------------------------
JKC's Profile: http://www.excelforum.com/member.php...o&userid=31166
View this thread: http://www.excelforum.com/showthread...hreadid=509517

sumproduct vs dsum
 

SUMPRODUCT calculates arrays, so it takes longer, but it can do more than
DSUM, SUMIF, etc. One thing you want to check is whether SUMPRODUCT is
calculating larger arrays than it needs to. For example, don't use A:A when
A1:A500 will do. (assuming you're not listening for ET, avoid VLAs ;-)

"JKC" wrote in message
...

RIght now in my workbook, I have several hundred SUMPRODUCT formulas.
This causes workbook calculatin to be extremly slow. Would DSUM
function help speed this up? I am very familiar with this function,
but have not used it in many places at once. I don't want to replace
SUMPRODUCT unless it will give me a noticable increase in calc speed.
Please let me know your opinion on this. Thanks a lot

JKC


--
JKC
------------------------------------------------------------------------
JKC's Profile:
http://www.excelforum.com/member.php...o&userid=31166
View this thread: http://www.excelforum.com/showthread...hreadid=509517