Look for a macro which summarize all values to determine the sum of a specific category

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

Originally Posted by Mumps1

This macro assumes that the number of values to sum will always be 5. If that is not the case, the macro will have to be modifed.

Please Login or Register  to view this content.

Thank you very much for your help. It is not always 5. How can I determine the numbers/range correctly?
Thanks, Jonas1998

1)
Please don't quote whole posts -- it's just clutter.*If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

2)
try

Please Login or Register  to view this content.