Excel Formulas to Sum the values that Equal to One of Many Things!!

Here, we will discuss the formula used to sum the values in the cells that equal to one of many things in Excel Office 365. Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to sum the values in the cells that equal to one of many things

General Formula:

• To sum the values in the cells that equal one of many things in Excel, use the below formula.

=SUMPRODUCT(SUMIF(range,things,values))

Syntax Explanations:

• SUMPRODUCT – In Excel, this function will help to multiply the corresponding array or range and return the result as the sum of the product. Read more on the SUMPRODUCT Function.
• SUMIF – The Excel SUMIF Function will help to sum the cells that meet a single condition or criteria.
• (Things) Criteria– It is the specific text or criteria that is used to sum the values.
• Range – It represents the input range given in the worksheet.
• Comma symbol (,) – It is a separator which helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.
• Value – It represents the input values given in the worksheet.

Example:

• Let’s consider the below image to sum the values in the cells.
• Here, we will enter the input values in Column B and Column C.
• Then, enter the given formula in the formula bar section.
• Finally, it will display the result as shown in the below image.

Example

Summary:

This page gives you a detailed view of the formula used to sum the values in the cells that equal to one of many things in Excel Office 365. Hope you like this article. IF you have any suggestions, don’t forget to share it with us. Thank you so much for Reading!! Keep learning on Geek Excel!! *and Excel Formulas *!!