# Question

#### aroraaj

##### Board Regular
I have two excel sheet. In one of the excel sheet I have two columns one for part name and the other for Single Source. My second sheet has 9 columns. It has Part Name, Gold Supplier, Gold Point, Capacity Ranking, Capacity Ranking Data, Scorecard, Scorecard Data, Quality Card, Quality Card Data.

Basically I have to add a formula in my first sheet and if the second column has Single Source listed I don't have to do anything but if its blank I need to calculate Gold Points + Capacity Ranking Data + Scorecard Data + Quality Card Data.

Is there a way to do that...I was thinking of doing VLOOKUP by matching the part name but I'm not sure how that'll work by adding the data.

Thanks

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
This will sum every other column in B:I for the row that contains the Part Name in column A:

=IF(B2="","",SUMPRODUCT(INDEX(Sheet2!\$B\$2:\$I\$3,MATCH(A2,Sheet2!A\$2:A\$3,FALSE),0),--(MOD(COLUMN(INDEX(Sheet2!\$B\$2:\$I\$3,MATCH(A2,Sheet2!A\$2:A\$3,FALSE),0)),2)=1)))

Adjust the sheet and range references to suit.

Replies
1
Views
955
Replies
6
Views
330
Replies
0
Views
1K
L
Replies
6
Views
415
Legacy 487876
L
Replies
3
Views
1K

1,196,414
Messages
6,015,123
Members
441,873
Latest member
saustark

### 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