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

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

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,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.
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