calculation speed of dsum vs sumifs

[faizee]

Dear all
I have
dsum formula =DSUM(for_dsum,'raw data'!L4,'manual entries'!O2:P3)

and
sumifs formula = =SUMIFS('sales history'!quantity,nature,"@",month_year,MONTH(C$2)&YEAR(C$2))

total no of raws is 11,000

can anybody tell me which formula works faster

thank you
Regards,

 

[XOR LX]

Hi

Never tested myself, though if there's one person who'll know it's Charles Williams (of Advanced Microsoft Excel Consultancy and Solution Development -Decision Models), and he says here:

Dsum vs SumIf performance | PC Review

that "DSUM is faster than SUMIF, particularly with multiple conditions."

Regards

 

[oldbrewer]

I tried to time something a few weeks ago (having disconnected PC from internet) and found times of 63,64,67,and 119 seconds....