count sorted values

I would like to count (make a sum) like the example below, which is sorted to ID1. But because of the reference Excel uses, the sum is not stable when I re-sort the whole table to ID2. How can I solve this?

ID1 ID2 NAME VALUE SUM FUNCTION
1 12 GROUP ID1 2-4 0 16 sum(D3:D5)
2 9 1
3 5 5
4 10 10
5 7 GROUP ID1 6-8 0 75 sum(D7:D9)
6 8 20
7 11 25
8 1 30
9 3 GROUP ID1 10-12 0 135 sum(D11:D13)
10 2 40
11 4 45
12 6 50


ID1 ID2 NAME VALUE SUM FUNCTION
8 1 30
10 2 40
9 3 GROUP ID1 10-12 0 100 sum(D11:D13)
11 4 45
3 5 5
12 6 50
5 7 GROUP ID1 6-8 0 31 sum(D7:D9)
6 8 20
2 9 1
4 10 10
7 11 25
1 12 GROUP ID1 2-4 0 0 sum(D3:D5)

(how do I paste an excel table?)

sumif is not really an option since it takes way to long to program

if there is a name in a row:
=SUMPRODUCT($D$2:$D$13,--($A$2:$A$13>=--MID(C2,FIND($A$1,C2)+4,FIND("-",C2)-FIND($A$1,C2)-4)),--(A2:A13<=--MID(C2,FIND("-",C2)+1,10)))

Thanks for the answer, when I change your last array into $A$2:$A$13 it works!
but isn't there an easier way? Because this example is a simplified version of wat I really need to do and that are +- 100 groups of 5 - 20 records. So this will take too much time to program.
It feels so basic that there should be something like adding a $ to make it stick to the cell.