Hello,
my excel sheet looks like this.
excel_stackoverflow1.PNG

I want to summarize all values below #N/A.
  • 2
  • 3
  • 4
  • 6
  • 9

The sum belongs to the Kategorie "11111".

The next are:
  • 1
  • 2
  • 3
  • 4
  • 5

and so on. Means please summarize all values under N/A and write the sum in the Column C. (Refer to the picture).
Then if you see another #NV, start again with summarizing.

I can't do that manually because I have almost 20.000 rows.

Please help me to find a better solution. Thanks