Adds the numbers in a column of a list or database that match conditions you specify.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
DSUM(database, field, criteria)DSUM is a database function that performs conditional summation based on a criteria range. It is particularly useful when you need to filter data by multiple criteria across different columns before calculating the total.
=DSUM(A1:C10, "Sales", E1:F2)결과: 1500
Sums the 'Sales' column for all rows where the 'Region' is 'North' as defined in the criteria range E1:F2.
Yes, you can add more rows or columns to your criteria range to filter by multiple conditions simultaneously.