Hi Jerome,
You would need to write a macro.
Do you only have Level 1 and Level 2

You would have to generate formulas where you have 1 in column A
with a macro if that is the case. The numbers are just random constants for test.


=SUBTOTAL9,D2:D14)
=SUBTOTAL(9,D3:D5)
8
37
52
=SUBTOTAL(9,D7:D7)
46
=SUBTOTAL(9,D9:D14)
76
11
81
69
61
83