what is the difference between sum and dsum in excel?
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.