## How to sum multiple columns based on single criteria in Excel?

In Excel, you may always need to sum multiple columns based on one criteria. For example, I have a range of data as following screenshot shown, now, I want to get the total values of KTE in three months - Jan, Feb and Mar.

**Sum multiple columns based on single criteria with a helper column**

**Sum multiple columns based on single criteria with an array formula**

**Sum multiple columns based on single criteria with an awesome feature**

** Sum multiple columns based on single criteria with a helper column**

In Excel, we can create a helper column to sum the total values for each row, and then use the sumif function to sum this column based on criteria, please do as this:

**1**. In this example, you can sum the total values for each row first, please type this formula: **=sum(B2:D2)**, then drag the fill handle down to the cells that you want to apply this formula, and the total values of each row will be displayedsee screenshot:

**2.** And next, you can apply the below sumif function to sum the data in helper column E based on the criteria:

**=SUMIF(A2:A10, G2, E2:E10)**

Then, press **Enter** key on the keyboard, and you will get the total number based on the specific criteria. See screenshot:

**Tips**: In the above formula：

refers to the range of cells that you want to apply the criteria against;**A2:A10**is the criterion that the items are to be added;**G2**specifies the cells to be added.**E2:E10**

**lookup and sum all the matching values in rows or columns**

**Kutools for Excel**'s **LOOKUP and Sum** feature helps you to lookup the specific value and get the summation of all the matching values in rows or columns as you need.** Click to download Kutools for Excel!**

**Kutools for Excel**: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.** Download and free trial Now! **

** Sum multiple columns based on single criteria with an array formula**

If you don’t like to use the helper column to solve this problem, here also is an array formula that can do you a favor.

**1**. Enter or copy the following formula in your specific cell - G2:

**=SUM((B2:B10+C2:C10+D2:D10)*(--(A2:A10=F2)))**

**2**. And then press the** Ctrl + Shift +Enter** keys together, and you will get the correct result.

**Tips**: In the above formula：

,**B2:B10**and**C2:C10**, indicate the columns that you want to sum, if you have more columns data need to sum, just add the column range as your need;**D2:D10**refers to the range of cells that you want to apply the criteria against;**A2:A10**is the criterion that the items are to be added.**F2**

** Sum multiple columns based on single criteria with an awesome feature**

to deal with this task as quickly as possible, Kutools for Excel's LOOKUP and Sum feature also can help you.

**Tips:**To apply this ** LOOKUP from Bottom to Top** feature, firstly, you should download the **Kutools for Excel**, and then apply the feature quickly and easily.

After installing **Kutools for Excel**, please do as this:

**1**. Click **Kutools** > **Super LOOKUP** > **LOOKUP and Sum**, see screenshot:

**2**. In the **LOOKUP and Sum** dialog box, please do the following operations:

- Select
**Lookup and sum matched value(s) in row(s)**option under the**Lookup and Sum Type**section; - Specify the lookup value, output range and the data range that you want to use;
- Select
**Return the sum of all matched values**option from the**Options**.

**3**. Then, click **OK** button, and the total value of all the matched records has been calculated at once, see screenshot:

** Download and free trial Kutools for Excel Now! **

** More relative articles:**

**Sumif with multiple criteria in one column**- In Excel, SUMIF function is a useful function for us to sum cells with multiple criteria in different columns, but with this function, we can also sum cells based on multiple criteria in one column. In this article. I will talk about how to sum values with more than one criteria in same column.

**Sumif with one or more criteria in Excel**- In Excel, sum values based on one or more criteria is a common task for most of us, the SUMIF function can help us to quickly sum the values based on one condition and the SUMIFS function help us to sum values with multiple criteria. This article, I will describe how to sum with one or more criteria in Excel?

**Sumif Cell Values Between Two Given Dates In Google Sheets**- In my Google sheet, I have two columns which contain a date column and order column, now, I want to sum the order column cells based on the date column. For example, sum values between 2018/5/15 and 2018/5/22 as following screenshot shown. How could you solve this job in Google sheets?

**Sum Cells When Value Changes In Another Column**- When you work on Excel worksheet, sometime, you may need to sum cells based on group of data in another column. For example, here, I want to sum the orders in column B when the data changes in column A to get the following result. How could you solve this problem in Excel?

**Vlookup Across Multiple Sheets And Sum Results In Excel**- Supposing, I have four worksheets which have the same formatting, and now, I want to find the TV set in the Product column of each sheet, and get the total number of order across those sheets as following screenshot shown. How could I solve this problem with an easy and quick method in Excel?

### Best Office Productivity Tools

**Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. ** **Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...**

#### Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!