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

[Sarhu]

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!

 

[dermie_72]

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]

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]

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