Question: what is the difference between excel's sum and dsum function?
Answer: DSUM finds results based on the given conditions from the whole database that includes the column names. In SUMIFS you can select data from different as well as distant column ranges. The field labels are not necessary. You must include the column ranges individually in the formula, not as a whole.