visual+basic+excel - Sum

Hi Eunhye

Thank you for your question.

The SUMIF function allows you to ask Excel to look in a column for one specific criteria, and then find corresponding values from the same column or a different column and add those values together.

The DSUM function allows you to ask Excel to look for criteria from multiple columns and then find corresponding values and add them together.

So the main difference between them is that SUMIF allows you to look for criteria in one column only whereas DSUM allows you to look for criteria in more than one column.

I hope this helps.
Amanda