Ask Your Question
0

Summarize rows based on multiple cells

asked 2017-08-23 18:22:24 +0100

chx gravatar image

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|
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2017-08-23 18:56:06 +0100

erAck gravatar image

updated 2017-08-23 19:00:02 +0100

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.

edit flag offensive delete link more

Comments

On the last versions Menu/Insert Pivot table.

m.a.riosv gravatar imagem.a.riosv ( 2017-08-24 01:39:38 +0100 )edit

Actually at both places :-)

erAck gravatar imageerAck ( 2017-09-04 21:10:33 +0100 )edit

Thanks for the insight.

m.a.riosv gravatar imagem.a.riosv ( 2017-09-04 22:48:31 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-08-23 18:22:24 +0100

Seen: 40 times

Last updated: Aug 23 '17