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
Bookmarks