Home > Blockchain >  Sum rows until customer number changes
Sum rows until customer number changes

Time:02-09

How can I sum the rows of product sales 1-3, until the Customer Code changes? Then the next Customer sales should be summed up. There may be customers with only 1 or 2 products also.

enter image description here

CodePudding user response:

This is exactly the reason why the subtotals feature has been invented. Hereby a screenshot (not in English, sorry):

enter image description here

Excel picture

  •  Tags:  
  • Related