Use SUMIFS in Excel to Add Values by Name
Question details
Add values in one column when the corresponding names in another column match one or more specified names.

- 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.
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.
Use SUMIFS to total amounts for selected names
Use a cell reference for one name or an array of names for a combined total.
Type the name to match, such as Jerry, in cell F2.
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.
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.

Create a PivotTable to summarize totals by name
Use a PivotTable when you want to see totals for all names rather than write a formula for each one.
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. Open the workbook: Open WPS Office, select Open, and choose your Excel workbook.
- 2. Enter the name: In the worksheet, type the name you want to match in cell F2.
- 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. Calculate and save: Press Enter to display the total, then choose File > Save to save your changes.

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.




