Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DSUM vs sumproduct
Well guys, I'm trying to speed up calculations. To this extent I was
wondering if DSUM is faster than Sumproduct... brain tells me it should be since sumproduct involves multiplication, and Dsum just logical sums.... But a newbie to Excel, so not sure how the engine functions!!!! Similarly, say if you had the formula "sum(A:A)" being used at two places and you "store" this formula somewhere and reference to it (rather the values it calculates), would it be faster than having this forumla repeating in the two columns? Thanks for the advise(s) |
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 vs. SUMPRODUCT | Excel Programming | |||
DSUM or SUMPRODUCT? | Excel Worksheet Functions | |||
sumproduct vs dsum | Excel Worksheet Functions |