• ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
Excel

How to Sum Same Codes in Excel

0 Comments

How to Sum Same Codes in Excel: Summing the same codes in Excel is a task that many people encounter in their work, especially when working on statistics/summaries. Whether you need to sum the quantity or total amount of specific product codes, Excel provides several functions that can help you accomplish this task quickly and accurately. In this article from Buffcom.net, we will show you how to use the SUMIF and SUMPRODUCT functions to sum the same codes in Excel.

For example, we have a data table as shown in the figure below. We need to sum the total amount of all tea products.

How to Sum Same Codes in Excel

How to Sum Same Codes in Excel

1. Use SUMIF function

As you can see in the figure above, there are 3 types of tea: peach tea, lemon tea, and kumquat tea. To sum the total amount of each tea type, we need to use the SUMIF function combined with the asterisk (*) as a wildcard character according to the formula:
=SUMIF(range of condition reference, “”& “search string”&””, range to sum)

Applying this formula to the spreadsheet, we will have the following formula to sum the total amount of each tea product:

=SUMIF(B2:B10;””&”Tea”&””;E2:E10)

How to Sum Same Codes in Excel

How to Sum Same Codes in Excel

2. Use SUMPRODUCT function

Another way to sum the total amount of tea products is to use the SUMPRODUCT function combined with the IFERROR and SEARCH functions. Enter the formula below into Excel and then press the Ctrl + Shift + Enter key combination.
=SUMPRODUCT((E2:E10)*(IFERROR(SEARCH(“Tea”;B2:B10);0)>0))

With the above formula, the IFERROR(SEARCH(“Tea”;B2:B10);0) function will search for cells in column B that contain the string “Tea” and return a value greater than 0, or return 0 if not found. When this formula is entered into the SUMPRODUCT function, Excel will compare the result to >0 and sum the corresponding total amount in column E.

Although the SUMPRODUCT formula is an array formula, which means you don’t have to use the Ctrl + Shift + Enter key combination in regular cases, for this case, you must use this key combination or you will not get accurate results.

How to Sum Same Codes in Excel

How to Sum Same Codes in Excel

In conclusion, summing the same codes in Excel is a common task in many workplaces. By using the SUMIF or SUMPRODUCT functions, you can quickly and accurately sum the quantity or total amount of specific codes. These functions can save you time and effort when working with large data sets, making them essential tools for data analysis in Excel.

We hope that this guide has been helpful to you and that you can use these functions to simplify your work. As always, practice makes perfect, so don’t be afraid to experiment with different formulas to find the best one for your needs.

Rate this post
46
324 Views
Using PivotTable for Reporting and Statistics in ExcelPrevUsing PivotTable for Reporting and Statistics in ExcelMarch 6, 2023
Excel Cost Management Accounting in BusinessMarch 6, 2023Excel Cost Management Accounting in BusinessNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Windows 11 Pro Product Activation Key Windows 11 Pro Product Activation Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Buy Windows 11 Pro CD Key License Buy Windows 11 Pro CD Key License
    Rated 5.00 out of 5
    $6.00
Products
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 1 Year AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 1 Year
    Rated 4.91 out of 5
    $34.00
  • Windows Server 2016 Datacenter Key Global Windows Server 2016 Datacenter Key Global
    Rated 4.74 out of 5
    $10.00
  • SQL Server 2019 Standard SQL Server 2019 Standard $20.00
  • Avast Premium Security 2021 10 Devices 2 Years Global Avast Premium Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $41.00
  • Microsoft Office Professional Plus 2010 retail Microsoft Office Professional Plus 2010 retail Key Global - 5 PC
    Rated 4.96 out of 5
    $15.00
  • Windows Server 2012 R2 Datacenter Key Global Windows Server 2012 R2 Datacenter Key Global
    Rated 4.71 out of 5
    $15.00
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • SQL Server 2014 Standard SQL Server 2014 Standard $20.00
  • Windows Server 2019 Remote Desktop Services 50 USER Connections Key Global Windows Server 2019 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.75 out of 5
    $20.00
  • Windows Server2008 R2 Remote Desktop Services user connections (20)cal Windows Server2008 R2 Remote Desktop Services user connections (20)cal $29.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.