{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"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":"Feuil1","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"cinema ugc",null,"billeterie","chèque",5.4,3,null,"peche",{"$f":"SUMIF(B:B,I2,G:G)","v":1},"cinema ugc"]
[null,"cinema kinepolis",null,"billeterie","chèque",6.2,3,null,null,null,"cinema kinepolis"]
[null,"cinema kinepolis",null,"billeterie","chèque",0.62,6,null,null,null,"zoo amneville adultes"]
[null,"zoo amneville adultes",null,"billeterie","chèque",25.4,2,null,null,null,"rivadis"]
[null,"rivadis",null,"rivadis","chèque",28.7,1,null,null,null,"divers"]
[null,"divers",null,"divers","chèque",191.22,1,null,null,null,"peche"]
[null,"divers",null,"divers","chèque",100,1]
[null,"peche",null,"peche","chèque",40,1]
[]
[]
[]
[]
["1) En colonne K (par exemple !) tu fais la liste de tous tes détails ventes (mettre un seul de chaque !!!)"]
["2) En I2 (par exemple !) tu crées par validation des données une liste que tu pourras mofidier par la petite flèche qui apparait quand tu vas sur la cellule"]
["3) En J2 (par exemple !) tu écris la formule =somme.si(b:b;i2;g:g)"]
["4) quand tu veux connaître la somme de tel ou tel détail ventes, tu changes la valeur de la celleul I2 par la petite flèche"]

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

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