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

Sarhu

New Member
Joined
Jan 6, 2014
Messages
2
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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

dermie_72

Well-known Member
Joined
Sep 4, 2012
Messages
1,540
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
Joined
Jan 6, 2014
Messages
3
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
Joined
Jan 6, 2014
Messages
2
Thanks! Not sure why I didn't think about using a pivot. I think my xmas/new years holiday was too long! :)
 

Forum statistics

Threads
1,137,298
Messages
5,680,684
Members
419,924
Latest member
Dhamodharan992

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top