## DEV Community is a community of 557,027 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

# Excel Formulas to Sum Multiple Columns using One Criterion!! Andrews Originally published at geekexcel.com on ・2 min read

Here, we will see the formulas used to sum the values in multiple columns using one criterion in Excel Office 365. Further, you can learn the basic syntax with the best example. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

## General Formula:

• To sum the values in multiple columns with one criterion, use the below formula.

=SUMPRODUCT((criteria_rng=”X”)*(sum_range))

## Syntax Explanations:

• SUMPRODUCT – In Excel, the SUMPRODUCT Function will help to multiply the corresponding array or range and return the result as the sum of the products.
• 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.
• Criteria_range – It is the input range that contains specific values or criteria.
• Sum_Range – It represents the input values given in the worksheet.
• Criteria (X)- It is the specific value or criteria that helps to sum the values.

## Example:

• Let’s consider the below image will show how to sum the values in multiple columns.
• Refer to the below image.
• Here, we will enter the input values in Column B to Column E.
• After that, enter the given formula in the selected area.
• Finally, we will get the result in Cell H3. 