Fill the data Fill the criteria: ="=Kate" Fill the formula: =DSUM(A1:C4,"Salary",D1:D2) Press Enter to get the result