{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil2","Feuil1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":9,"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":"Feuil2","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,8,6,8],[31,5,31,6],[14,2,14,3]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Référence"]
[]
[null,null,null,null,null,null,null,null,98]
[]
[null,null,null,null,null,"TOTAL 1","TOTAL 2","UNITE","MONTANT 1","MONTANT 2"]
[null,null,null,null,null,null,{"$f":"H11*J11","v":25},1,null,25]
[null,null,null,null,null,null,{"$f":"H12*J12","v":50},1,null,50]
[null,null,null,null,null,{"$f":"H13*I13","v":98},null,1,98]
[null,null,null,null,null,null,{"$f":"H14*J14","v":18},1,null,18]
[null,null,"Pouvoir cacher",null,null,null,{"$f":"H15*J15","v":44},1,null,44]
[null,null,null,null,null,{"$f":"H16*I16","v":98},null,1,{"$f":"I8","v":98}]
[null,null,"SI on retrouve la somme de I8",null,null,null,null,1]
[null,null,"plus d'une fois dans colonne F",null,null,null,{"$f":"H18*J18","v":21},1,null,21]
[null,null,"les cellules contenant cette somme",null,null,null,null,1]
[null,null,"doivent etres cachées",null,null,null,null,1]
[null,null,null,null,null,98,null,1,{"$f":"I8","v":98}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"INDEX(F11:F28,MATCH(I8,I11:I28,0))","v":98},{"$f":"SUM(G11:G28)","v":158}]
[]
[null,null,null,"Résultat Final",null,{"$f":"F30+G30","v":256}]
[]
[null,null,"J'aimerai avoir une formule qui me donne que le premier montant trouvé, cad  98 ici mais cela peut changer de somme indiqué en I8 Référence"]

{"sheet":"Feuil1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}