# Find a row based on multiple criteria and then sum up items that are in that row to the right.

#### agcoleman

##### New Member
I am trying to find a formula or combination of formulas so that I can find a row and the sum up some values that are in that same row but to the right.
The picture below gives an example. I need to be able to write a formula that will look at the first 4 columns and match them to a criteria on a different tab. Once that row is found I need to be able to sum the cells that are out to the right.

 criteria 1 criteria 2 criteria 3 criteria 4 Cell to sum Cell to sum Cell to sum Cell to sum A B C D 1​ 2​ 3​ 4​ E B C D 2​ 3​ 4​ 5​

### Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Hi & welcome to MrExcel.
Can you post what your criteria are & how it's laid out.

Hi & welcome to MrExcel.
Can you post what your criteria are & how it's laid out.
The attached picture should give you a better idea.
I need to be able to look at the criteria in columns B through U and match those to an identical setup on another tab. Once the criteria in columns B through U have been matched then I want to sum up that row in columns V-Z.

#### Attachments

• example.PNG
46.1 KB · Views: 9
With that many columns to match, are you happy to use a helper column?

If I am not miss-interpreting you requirement
is that what you want?

Sheet1

Book3
ABCDEFGH
1Criteria 1Criteria 2Criteria 3Criteria 4Cell to SumCell to SumCell to SumCell to Sum
2ABCD1234
3EBCD2345
Sheet1

Sheet2

Book3
ABCDE
1Criteria 1Criteria 2Criteria 3Criteria 4Sum
2ABCD10
3EBCD14
Sheet2
Cell Formulas
RangeFormula
E2:E3E2=IF(CONCATENATE(Sheet1!A2,Sheet1!B2,Sheet1!C2,Sheet1!D2)=CONCATENATE(A2,B2,C2,D2),SUM(Sheet1!E2:H2),0)

That assumes the matches will be on the same row on both sheets, which from what the OP has said, I doubt.

You are right Fluff, I just realized after posting.

That assumes the matches will be on the same row on both sheets, which from what the OP has said, I doubt.
Correct, the criteria will be on different rows in the second sheet so it can't reference a specific row. It will be on various rows on sheet two.

And the answer to my question in post#4?

With that many columns to match, are you happy to use a helper column?
I am open to it if that is the only way.

Replies
5
Views
205
Replies
1
Views
73
Replies
1
Views
66
Replies
1
Views
296
Replies
2
Views
338

1,206,819
Messages
6,075,045
Members
446,115
Latest member
orlamag

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back