Hello
If I understand it correctly, you may try something like the following tables.
Invoice
A1 Name
A2 D
A3 =IF(E$2=0,"",IFERROR(INDEX(Names::A,MATCH(E$2&"|"&ROW()-2+IF(ROW()-2<F$2,0,1),Names::D,0),1),""))
A4 =IF(E$2=0,"",IFERROR(INDEX(Names::A,MATCH(E$2&"|"&ROW()-2+IF(ROW()-2<F$2,0,1),Names::D,0),1),""))
A5 =IF(E$2=0,"",IFERROR(INDEX(Names::A,MATCH(E$2&"|"&ROW()-2+IF(ROW()-2<F$2,0,1),Names::D,0),1),""))
A6 =IF(E$2=0,"",IFERROR(INDEX(Names::A,MATCH(E$2&"|"&ROW()-2+IF(ROW()-2<F$2,0,1),Names::D,0),1),""))
A7 =IF(E$2=0,"",IFERROR(INDEX(Names::A,MATCH(E$2&"|"&ROW()-2+IF(ROW()-2<F$2,0,1),Names::D,0),1),""))
A8
B1 # Events
B2 =IF(LEN(A2)>0,COUNTIF(Events::A,A2),"")
B3 =IF(LEN(A3)>0,COUNTIF(Events::A,A3),"")
B4 =IF(LEN(A4)>0,COUNTIF(Events::A,A4),"")
B5 =IF(LEN(A5)>0,COUNTIF(Events::A,A5),"")
B6 =IF(LEN(A6)>0,COUNTIF(Events::A,A6),"")
B7 =IF(LEN(A7)>0,COUNTIF(Events::A,A7),"")
B8
C1 Rate
C2 =IFERROR(VLOOKUP(A2,Names::A:B,2,0),"")
C3 =IFERROR(VLOOKUP(A3,Names::A:B,2,0),"")
C4 =IFERROR(VLOOKUP(A4,Names::A:B,2,0),"")
C5 =IFERROR(VLOOKUP(A5,Names::A:B,2,0),"")
C6 =IFERROR(VLOOKUP(A6,Names::A:B,2,0),"")
C7 =IFERROR(VLOOKUP(A7,Names::A:B,2,0),"")
C8
D1 B*C
D2 =IF(LEN(B2)>0,B2*C2,"")
D3 =IF(LEN(B3)>0,B3*C3,"")
D4 =IF(LEN(B4)>0,B4*C4,"")
D5 =IF(LEN(B5)>0,B5*C5,"")
D6 =IF(LEN(B6)>0,B6*C6,"")
D7 =IF(LEN(B7)>0,B7*C7,"")
D8 =SUM(D)
E1 Family
E2 =VLOOKUP(A2,Names::A:C,3,0)
E3
E4
E5
E6
E7
E8
F1
F2 =0+SUBSTITUTE(VLOOKUP(A2,Names::A:D,4,0),E2&"|","")
F3
F4
F5
F6
F7
F8
Names
A1 Name
A2 A
A3 B
A4 C
A5 D
A6 E
A7 F
A8 G
B1 Rate
B2 10
B3 10
B4 10
B5 15
B6 15
B7 20
B8 10
C1 Family
C2 FA
C3 0
C4 FC
C5 FA
C6 0
C7 FC
C8 FA
D1
D2 =C2&"|"&COUNTIF(C$2:C2,C2)
D3 =C3&"|"&COUNTIF(C$2:C3,C3)
D4 =C4&"|"&COUNTIF(C$2:C4,C4)
D5 =C5&"|"&COUNTIF(C$2:C5,C5)
D6 =C6&"|"&COUNTIF(C$2:C6,C6)
D7 =C7&"|"&COUNTIF(C$2:C7,C7)
D8 =C8&"|"&COUNTIF(C$2:C8,C8)
Tables are built with Numbers v2.
Good luck,
H
EDIT: added another screenshot