Ask Your Question

How to sum up values by ID

asked 2015-09-29 11:32:52 +0200

forrest gravatar image

I want to sum the values in column B so that I only got displayed the IDs once and the sum of the regarding values. Here is a screenshot from what I mean:

I would expect to have a row with ID 111 and value 9

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-09-30 19:47:31 +0200

LKeithJordan gravatar image

You could create a pivottable or you could use the SUMIF function to accomplish what you describe.

edit flag offensive delete link more

answered 2015-09-29 13:36:52 +0200

karolus gravatar image

Thats for →Data→Pivottable...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2015-09-29 11:32:52 +0200

Seen: 353 times

Last updated: Sep 30 '15