Function Problems

Use SUMIFS in Excel to Add Values by Name

Phi Hung VoPhi Hung Vo Nov 14, 2026 869 views

Question details

Add values in one column when the corresponding names in another column match one or more specified names.

Use SUMIFS in Excel to Add Values by Name
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet has amounts in column C and names in column D, and the user wants totals for selected names.
Observed behavior
The desired result is a sum of the amounts associated with each specified name.
Before you start

Check that the amounts in column C are numeric and that the corresponding names are in the same rows in column D. Adjust the example ranges to match your worksheet.

Solution 1Recommended

Use SUMIFS to total amounts for selected names

Use a cell reference for one name or an array of names for a combined total.

1
Enter a name

Type the name to match, such as Jerry, in cell F2.

2
Calculate the total

Select an empty cell and enter =SUMIFS($C$2:$C$13,$D$2:$D$13,F2), then press Enter. The formula adds amounts in C2:C13 where the corresponding name in D2:D13 matches F2.

3
Combine two names

To get one total for Jerry and Devin, enter =SUM(SUMIFS($C$2:$C$13,$D$2:$D$13,{"Jerry","Devin"})) in an empty cell and press Enter.

Use SUMIFS to total amounts for selected names
Keep ranges aligned: The sum range and name range must cover the same number of rows. Dollar signs keep the ranges fixed if you copy the formula.
Add values by name

Calculate name-based totals in WPS Spreadsheets

Open your workbook in WPS Spreadsheets and use SUMIFS to add amounts that match a name in another column.

  1. 1. Open the workbook: Open WPS Office, select Open, and choose your Excel workbook.
  2. 2. Enter the name: In the worksheet, type the name you want to match in cell F2.
  3. 3. Enter the formula: Select an empty cell and enter =SUMIFS($C$2:$C$13,$D$2:$D$13,F2), adjusting the ranges to fit your data.
  4. 4. Calculate and save: Press Enter to display the total, then choose File > Save to save your changes.
Calculate totals for individual names with SUMIFSOpen and edit Microsoft Excel XLSX and XLS filesChange the name in a referenced cell to recalculate the totalWork in a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

How do I change which name SUMIFS totals?

If your formula uses F2 as its criterion, replace the name in F2. The total will recalculate for the new name.

Can I add totals for Jerry and Devin without an array formula?

Yes. Enter =SUMIFS($C$2:$C$13,$D$2:$D$13,"Jerry")+SUMIFS($C$2:$C$13,$D$2:$D$13,"Devin") in an empty cell.

Why does my SUMIFS formula return zero?

Check that the name in F2 matches the entries in D2:D13, including any extra spaces, and that the amounts in C2:C13 are stored as numbers rather than text.

How can I see totals for every name at once?

Select your data and choose Insert > PivotTable. Add the name field to Rows and the amount field to Values, then set the value calculation to Sum if needed.