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)