{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["LISTE","RECAP"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"LISTE","index":0,"n_rows":100,"n_cols":7,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["client","commande","date","montant",null,null,"code"]
["jack",2589,"2015-01-10","2693 ",null,null,{"$f":"IF(A2=\"\",\"\",IF(COUNTIFS($A$2:A2,A2,$C$2:C2,C2)>1,\"\",MAX($G$1:G1)+1))","v":1}]
["jack",53177,"2015-01-10","1889 ",null,null,{"$f":"IF(A3=\"\",\"\",IF(COUNTIFS($A$2:A3,A3,$C$2:C3,C3)>1,\"\",MAX($G$1:G2)+1))","v":""}]
["michelle",72693,"2015-06-03","500 ",null,null,{"$f":"IF(A4=\"\",\"\",IF(COUNTIFS($A$2:A4,A4,$C$2:C4,C4)>1,\"\",MAX($G$1:G3)+1))","v":2}]
["john",12345,"2015-04-01","119 ",null,null,{"$f":"IF(A5=\"\",\"\",IF(COUNTIFS($A$2:A5,A5,$C$2:C5,C5)>1,\"\",MAX($G$1:G4)+1))","v":3}]
["michelle",15936,"2014-11-11","2580 ",null,null,{"$f":"IF(A6=\"\",\"\",IF(COUNTIFS($A$2:A6,A6,$C$2:C6,C6)>1,\"\",MAX($G$1:G5)+1))","v":4}]
["jack",2400,"2015-02-12",null,null,null,{"$f":"IF(A7=\"\",\"\",IF(COUNTIFS($A$2:A7,A7,$C$2:C7,C7)>1,\"\",MAX($G$1:G6)+1))","v":5}]
[null,null,null,null,null,null,{"$f":"IF(A8=\"\",\"\",IF(COUNTIFS($A$2:A8,A8,$C$2:C8,C8)>1,\"\",MAX($G$1:G7)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A9=\"\",\"\",IF(COUNTIFS($A$2:A9,A9,$C$2:C9,C9)>1,\"\",MAX($G$1:G8)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A10=\"\",\"\",IF(COUNTIFS($A$2:A10,A10,$C$2:C10,C10)>1,\"\",MAX($G$1:G9)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A11=\"\",\"\",IF(COUNTIFS($A$2:A11,A11,$C$2:C11,C11)>1,\"\",MAX($G$1:G10)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A12=\"\",\"\",IF(COUNTIF($A$2:A12,A12)>1,\"\",MAX($G$1:G11)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A13=\"\",\"\",IF(COUNTIF($A$2:A13,A13)>1,\"\",MAX($G$1:G12)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A14=\"\",\"\",IF(COUNTIF($A$2:A14,A14)>1,\"\",MAX($G$1:G13)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A15=\"\",\"\",IF(COUNTIF($A$2:A15,A15)>1,\"\",MAX($G$1:G14)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A16=\"\",\"\",IF(COUNTIF($A$2:A16,A16)>1,\"\",MAX($G$1:G15)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A17=\"\",\"\",IF(COUNTIF($A$2:A17,A17)>1,\"\",MAX($G$1:G16)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A18=\"\",\"\",IF(COUNTIF($A$2:A18,A18)>1,\"\",MAX($G$1:G17)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A19=\"\",\"\",IF(COUNTIF($A$2:A19,A19)>1,\"\",MAX($G$1:G18)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A20=\"\",\"\",IF(COUNTIF($A$2:A20,A20)>1,\"\",MAX($G$1:G19)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A21=\"\",\"\",IF(COUNTIF($A$2:A21,A21)>1,\"\",MAX($G$1:G20)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A22=\"\",\"\",IF(COUNTIF($A$2:A22,A22)>1,\"\",MAX($G$1:G21)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A23=\"\",\"\",IF(COUNTIF($A$2:A23,A23)>1,\"\",MAX($G$1:G22)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A24=\"\",\"\",IF(COUNTIF($A$2:A24,A24)>1,\"\",MAX($G$1:G23)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A25=\"\",\"\",IF(COUNTIF($A$2:A25,A25)>1,\"\",MAX($G$1:G24)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A26=\"\",\"\",IF(COUNTIF($A$2:A26,A26)>1,\"\",MAX($G$1:G25)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A27=\"\",\"\",IF(COUNTIF($A$2:A27,A27)>1,\"\",MAX($G$1:G26)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A28=\"\",\"\",IF(COUNTIF($A$2:A28,A28)>1,\"\",MAX($G$1:G27)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A29=\"\",\"\",IF(COUNTIF($A$2:A29,A29)>1,\"\",MAX($G$1:G28)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A30=\"\",\"\",IF(COUNTIF($A$2:A30,A30)>1,\"\",MAX($G$1:G29)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A31=\"\",\"\",IF(COUNTIF($A$2:A31,A31)>1,\"\",MAX($G$1:G30)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A32=\"\",\"\",IF(COUNTIF($A$2:A32,A32)>1,\"\",MAX($G$1:G31)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A33=\"\",\"\",IF(COUNTIF($A$2:A33,A33)>1,\"\",MAX($G$1:G32)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A34=\"\",\"\",IF(COUNTIF($A$2:A34,A34)>1,\"\",MAX($G$1:G33)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A35=\"\",\"\",IF(COUNTIF($A$2:A35,A35)>1,\"\",MAX($G$1:G34)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A36=\"\",\"\",IF(COUNTIF($A$2:A36,A36)>1,\"\",MAX($G$1:G35)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A37=\"\",\"\",IF(COUNTIF($A$2:A37,A37)>1,\"\",MAX($G$1:G36)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A38=\"\",\"\",IF(COUNTIF($A$2:A38,A38)>1,\"\",MAX($G$1:G37)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A39=\"\",\"\",IF(COUNTIF($A$2:A39,A39)>1,\"\",MAX($G$1:G38)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A40=\"\",\"\",IF(COUNTIF($A$2:A40,A40)>1,\"\",MAX($G$1:G39)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A41=\"\",\"\",IF(COUNTIF($A$2:A41,A41)>1,\"\",MAX($G$1:G40)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A42=\"\",\"\",IF(COUNTIF($A$2:A42,A42)>1,\"\",MAX($G$1:G41)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A43=\"\",\"\",IF(COUNTIF($A$2:A43,A43)>1,\"\",MAX($G$1:G42)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A44=\"\",\"\",IF(COUNTIF($A$2:A44,A44)>1,\"\",MAX($G$1:G43)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A45=\"\",\"\",IF(COUNTIF($A$2:A45,A45)>1,\"\",MAX($G$1:G44)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A46=\"\",\"\",IF(COUNTIF($A$2:A46,A46)>1,\"\",MAX($G$1:G45)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A47=\"\",\"\",IF(COUNTIF($A$2:A47,A47)>1,\"\",MAX($G$1:G46)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A48=\"\",\"\",IF(COUNTIF($A$2:A48,A48)>1,\"\",MAX($G$1:G47)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A49=\"\",\"\",IF(COUNTIF($A$2:A49,A49)>1,\"\",MAX($G$1:G48)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A50=\"\",\"\",IF(COUNTIF($A$2:A50,A50)>1,\"\",MAX($G$1:G49)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A51=\"\",\"\",IF(COUNTIF($A$2:A51,A51)>1,\"\",MAX($G$1:G50)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A52=\"\",\"\",IF(COUNTIF($A$2:A52,A52)>1,\"\",MAX($G$1:G51)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A53=\"\",\"\",IF(COUNTIF($A$2:A53,A53)>1,\"\",MAX($G$1:G52)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A54=\"\",\"\",IF(COUNTIF($A$2:A54,A54)>1,\"\",MAX($G$1:G53)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A55=\"\",\"\",IF(COUNTIF($A$2:A55,A55)>1,\"\",MAX($G$1:G54)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A56=\"\",\"\",IF(COUNTIF($A$2:A56,A56)>1,\"\",MAX($G$1:G55)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A57=\"\",\"\",IF(COUNTIF($A$2:A57,A57)>1,\"\",MAX($G$1:G56)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A58=\"\",\"\",IF(COUNTIF($A$2:A58,A58)>1,\"\",MAX($G$1:G57)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A59=\"\",\"\",IF(COUNTIF($A$2:A59,A59)>1,\"\",MAX($G$1:G58)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A60=\"\",\"\",IF(COUNTIF($A$2:A60,A60)>1,\"\",MAX($G$1:G59)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A61=\"\",\"\",IF(COUNTIF($A$2:A61,A61)>1,\"\",MAX($G$1:G60)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A62=\"\",\"\",IF(COUNTIF($A$2:A62,A62)>1,\"\",MAX($G$1:G61)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A63=\"\",\"\",IF(COUNTIF($A$2:A63,A63)>1,\"\",MAX($G$1:G62)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A64=\"\",\"\",IF(COUNTIF($A$2:A64,A64)>1,\"\",MAX($G$1:G63)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A65=\"\",\"\",IF(COUNTIF($A$2:A65,A65)>1,\"\",MAX($G$1:G64)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A66=\"\",\"\",IF(COUNTIF($A$2:A66,A66)>1,\"\",MAX($G$1:G65)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A67=\"\",\"\",IF(COUNTIF($A$2:A67,A67)>1,\"\",MAX($G$1:G66)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A68=\"\",\"\",IF(COUNTIF($A$2:A68,A68)>1,\"\",MAX($G$1:G67)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A69=\"\",\"\",IF(COUNTIF($A$2:A69,A69)>1,\"\",MAX($G$1:G68)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A70=\"\",\"\",IF(COUNTIF($A$2:A70,A70)>1,\"\",MAX($G$1:G69)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A71=\"\",\"\",IF(COUNTIF($A$2:A71,A71)>1,\"\",MAX($G$1:G70)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A72=\"\",\"\",IF(COUNTIF($A$2:A72,A72)>1,\"\",MAX($G$1:G71)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A73=\"\",\"\",IF(COUNTIF($A$2:A73,A73)>1,\"\",MAX($G$1:G72)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A74=\"\",\"\",IF(COUNTIF($A$2:A74,A74)>1,\"\",MAX($G$1:G73)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A75=\"\",\"\",IF(COUNTIF($A$2:A75,A75)>1,\"\",MAX($G$1:G74)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A76=\"\",\"\",IF(COUNTIF($A$2:A76,A76)>1,\"\",MAX($G$1:G75)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A77=\"\",\"\",IF(COUNTIF($A$2:A77,A77)>1,\"\",MAX($G$1:G76)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A78=\"\",\"\",IF(COUNTIF($A$2:A78,A78)>1,\"\",MAX($G$1:G77)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A79=\"\",\"\",IF(COUNTIF($A$2:A79,A79)>1,\"\",MAX($G$1:G78)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A80=\"\",\"\",IF(COUNTIF($A$2:A80,A80)>1,\"\",MAX($G$1:G79)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A81=\"\",\"\",IF(COUNTIF($A$2:A81,A81)>1,\"\",MAX($G$1:G80)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A82=\"\",\"\",IF(COUNTIF($A$2:A82,A82)>1,\"\",MAX($G$1:G81)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A83=\"\",\"\",IF(COUNTIF($A$2:A83,A83)>1,\"\",MAX($G$1:G82)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A84=\"\",\"\",IF(COUNTIF($A$2:A84,A84)>1,\"\",MAX($G$1:G83)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A85=\"\",\"\",IF(COUNTIF($A$2:A85,A85)>1,\"\",MAX($G$1:G84)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A86=\"\",\"\",IF(COUNTIF($A$2:A86,A86)>1,\"\",MAX($G$1:G85)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A87=\"\",\"\",IF(COUNTIF($A$2:A87,A87)>1,\"\",MAX($G$1:G86)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A88=\"\",\"\",IF(COUNTIF($A$2:A88,A88)>1,\"\",MAX($G$1:G87)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A89=\"\",\"\",IF(COUNTIF($A$2:A89,A89)>1,\"\",MAX($G$1:G88)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A90=\"\",\"\",IF(COUNTIF($A$2:A90,A90)>1,\"\",MAX($G$1:G89)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A91=\"\",\"\",IF(COUNTIF($A$2:A91,A91)>1,\"\",MAX($G$1:G90)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A92=\"\",\"\",IF(COUNTIF($A$2:A92,A92)>1,\"\",MAX($G$1:G91)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A93=\"\",\"\",IF(COUNTIF($A$2:A93,A93)>1,\"\",MAX($G$1:G92)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A94=\"\",\"\",IF(COUNTIF($A$2:A94,A94)>1,\"\",MAX($G$1:G93)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A95=\"\",\"\",IF(COUNTIF($A$2:A95,A95)>1,\"\",MAX($G$1:G94)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A96=\"\",\"\",IF(COUNTIF($A$2:A96,A96)>1,\"\",MAX($G$1:G95)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A97=\"\",\"\",IF(COUNTIF($A$2:A97,A97)>1,\"\",MAX($G$1:G96)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A98=\"\",\"\",IF(COUNTIF($A$2:A98,A98)>1,\"\",MAX($G$1:G97)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A99=\"\",\"\",IF(COUNTIF($A$2:A99,A99)>1,\"\",MAX($G$1:G98)+1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A100=\"\",\"\",IF(COUNTIF($A$2:A100,A100)>1,\"\",MAX($G$1:G99)+1))","v":""}]

{"sheet":"RECAP","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["client","Date","montant",null,"le système utilise la colonne G de LISTE qui peut être masquée, ou sur une autre feuille"]
[{"$f":"IFERROR(INDEX(LISTE!$A:$A,MATCH(ROW($A1),LISTE!$G:$G,0)),\"\")","v":"jack"},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A1),LISTE!$G:$G,0)),\"\")","v":"2015-01-10"},{"$f":"IF(A2=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A2,LISTE!C:C,B2))","v":55766}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A2),LISTE!G:G,0)),\"\")","v":"michelle"},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A2),LISTE!$G:$G,0)),\"\")","v":"2015-06-03"},{"$f":"IF(A3=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A3,LISTE!C:C,B3))","v":72693},null,"l'édition de la liste de RECAP  en A à partir du code de la colonne G de LISTE peut être remplacée par cette opération:"]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A3),LISTE!G:G,0)),\"\")","v":"john"},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A3),LISTE!$G:$G,0)),\"\")","v":"2015-04-01"},{"$f":"IF(A4=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A4,LISTE!C:C,B4))","v":12345},null,null,"1° copier le champ A de LISTE"]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A4),LISTE!G:G,0)),\"\")","v":"michelle"},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A4),LISTE!$G:$G,0)),\"\")","v":"2014-11-11"},{"$f":"IF(A5=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A5,LISTE!C:C,B5))","v":15936},null,null,"2° le coller sur A de RECAP"]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A5),LISTE!G:G,0)),\"\")","v":"jack"},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A5),LISTE!$G:$G,0)),\"\")","v":"2015-02-12"},{"$f":"IF(A6=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A6,LISTE!C:C,B6))","v":2400},null,null,"3° Ruban / Onglet Donnée / Suppirmer les doubloçns"]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A6),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A6),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A7=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A7,LISTE!C:C,B7))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A7),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A7),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A8=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A8,LISTE!C:C,B8))","v":""},null,"Ne fonctionne que sur Excel à partir de 2007"]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A8),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A8),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A9=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A9,LISTE!C:C,B9))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A9),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A9),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A10=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A10,LISTE!C:C,B10))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A10),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A10),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A11=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A11,LISTE!C:C,B11))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A11),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A11),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A12,LISTE!C:C,B12))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A12),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A12),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A13=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A13,LISTE!C:C,B13))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A13),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A13),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A14=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A14,LISTE!C:C,B14))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A14),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A14),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A15=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A15,LISTE!C:C,B15))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A15),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A15),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A16=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A16,LISTE!C:C,B16))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A16),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A16),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A17=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A17,LISTE!C:C,B17))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A17),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A17),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A18=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A18,LISTE!C:C,B18))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A18),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A18),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A19=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A19,LISTE!C:C,B19))","v":""}]
[{"$f":"IFERROR(INDEX(LISTE!A:A,MATCH(ROW(A19),LISTE!G:G,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(LISTE!$C:$C,MATCH(ROW($A19),LISTE!$G:$G,0)),\"\")","v":""},{"$f":"IF(A20=\"\",\"\",SUMIFS(LISTE!B:B,LISTE!A:A,A20,LISTE!C:C,B20))","v":""}]