View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JKC
 
Posts: n/a
Default 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