# How to Sum Names in Excel (4 Suitable Ways)

We’ll use the following dataset which contains order details. We’ll use the Product or Customer names to sum values.

## Method 1 – Sum for One or Multiple Names Using Excel SUMIF or SUMIFS Functions

Steps:

• For the total quantity and total order prices for Customer-1, put the following formulas in cells J5 and K5.

Formula for Total Quantity:

`=SUMIF(C5:C20, C5, F5:F20)`

Formula for Order Price:

`=SUMIF(C5:C20, C5, G5:G20)`

• We can apply the SUMIFS function to add more criteria. For the total order quantity and price for Customers only for those greater than 100 pieces, insert the following formula in cells J12 and K12.

Formula for Total Quantity (Which Are >100):

`=SUMIFS(F5:F20,C5:C20,C10, F5:F20,">100")`

Formula for Total Price (Whose Quantity Are >100):

`=SUMIFS(G5:G20,C5:C20,C10, F5:F20,">100")`

Note:

You could use “Customer-1” instead of C10 inside the formulas to set name criteria.

## Method 2 – Sum Names for Partial Matches in Excel

We have products such as shirts, t-shirts, and shorts. You see “sh” is common in these products’ names. We can set a formula using wildcard characters to get the total for all these products.

Steps:

• Go to cell J5 and insert the following formula.
`=SUMIF(E5:E20, "*Sh*", F5:F20)`
• Hit the Enter button.

## Method 3 – Performing a Summation of a Named Range in Excel

Steps:

• Select the product column.
• Rename it as Products via the name text box on the ribbon (left to the formula bar). Use an underscore (_) if you want to use two or more words in the name box.

• Rename the Quantity Column as Quantities.

• Apply the following formula in cell J5.
`=SUMIF(Products, "*Sh*", Quantities)`

We don’t have to use the range as a reference since we used named ranges.

## Method 4 – Using the Consolidate Option to Summarize the Total for Specified Names

We’ll combine the columns labeled Customer, Qty, and Total Price by consolidating.

Steps:

• Go to Consolidate under Data Tools under the Data tab.

• A Consolidate pop-up will then show up here.
• Select Sum in the Function area.
• Select the data range you want to consolidate. Here it is C5:G20.
• Mark Left Column under Use Labels.
• Click OK.

• We have some undesirable columns like the 2nd (K) and 3rd (L) column.
• Select the 2nd and 3rd columns, right-click, and select Delete.

• Here is the final data.

## Related Articles

Get FREE Advanced Excel Exercises with Solutions!
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF