Search code examples
excelcountgroupingexcel-2013

Count instances of string and quantity of those instances

I'm trying to find a way to make my excel sheet give me result data. I have a list of string items and a quantity of that string and I want to get a total quantity of that string. Example below.

[ROW]    [NAME]      [QTY]                     [results]
  1        PEN         1                        [PEN]         [6]
  2        PEN         2                        [PENCIL]      [5]                   
  3        PENCIL      5                        [MARKER]      [5]
  4        MARKER      5
  5        PEN         3

From this Excel sheet, I want to produce results on the right from the data on the left.

Solution

  • You could use a built-in feature of Excel called a Pivot Table.