How to sum up values by ID

English
, ,
#1

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: http://pasteboard.co/ZUpXea2.png

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

#2

Thats for →Data→Pivottable...

#3

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

#4

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.