Summarize rows based on multiple cells

[chx]

Let’s say columns 1-10 are identifiers and 11-15 are values. Identifiers might occur multiple times and I’d like to add up the values in each column. Example:

A1|B1|1|2|
A1|B1|5|3|
A2|B2|3|6|
A2|B2|4|2|

Should become

A1|B1|6|5|
A2|B2|7|8|

[erAck]

Pivot table is your friend. Make sure columns have a column header each (ie. cells above with names for the columns, for example name1, name2, value1, value2) and then use menu Data → Pivot Table… → Create, drag&drop name1 and name2 into Row Fields, and value1 and value2 into Data Fields, OK, ready.

[mariosv]

On the last versions Menu/Insert Pivot table.

[erAck]

Actually at both places

[mariosv]

Thanks for the insight.