# If(a1=a2), sum(c1+2)

#### Sarhu

##### New Member
 Item Size Concatenation Sales 11844 - BOYS' CARDIGAN - SPECIAL L 11844 - BOYS' CARDIGAN SPECIALL 55 11844 - BOYS' CARDIGAN - SPECIAL L 11844 - BOYS' CARDIGAN SPECIALL 70 11844 - BOYS' CARDIGAN - SPECIAL L 11844 - BOYS' CARDIGAN SPECIALL 30 11844 - BOYS' CARDIGAN - SPECIAL M 11844 - BOYS' CARDIGAN SPECIALM 59 11844 - BOYS' CARDIGAN - SPECIAL M 11844 - BOYS' CARDIGAN SPECIALM 147

<tbody>
</tbody>

I want to sum the sales column if the concatenation column values are the same. For example:

IF '11844 - BOYS' CARDIGAN SPECIALL'="'11844 - BOYS' CARDIGAN SPECIALL', SUM '55' + '70'

Help!

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

#### dermie_72

##### Well-known Member
i would try sumifs
=sumifs(C:C,A:A,A1,B:B,B1) But you would need to create a table on the side or in a new sheet of the unique values, and then sum the original table.

#### xl1der

##### New Member
I would just make a pivottable. Highlight the last two columns (Concatenation and Sales), click Insert>PivotTable, put Concatenation in the "Row Labels" box and Sum of Sales in the "Values" box. Does that work for you?

#### Sarhu

##### New Member
Thanks! Not sure why I didn't think about using a pivot. I think my xmas/new years holiday was too long!

Replies
3
Views
432
Replies
1
Views
682
Replies
2
Views
239
Replies
8
Views
452
Replies
1
Views
245

1,170,932
Messages
5,872,776
Members
432,944
Latest member
mj02

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