Search code examples
excelformattingsumpivot-tableexcel-2013

Sum and count values by group where group name shows once per group

Just had a post here, solved a simple question. Here is one more question.

How can I SUM all values for each Item if they are not on the same rows as their item's description? See Total Value:

enter image description here

Solution

  • This is in several elements:

    1 Convert your strings in ColumnB into values (select all green triangles, click on exclamation mark and on Convert to Number).
    2 Fill down (as in comment above)
    3 Pivot Table:

    SO29376013 example