sumproduct vs dsum

[JKC]

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

 

[Bob Tarburton]

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 ;-)