{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"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":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Variable",-1,"Dans mon exemple, G1 peut prende la valeur 0 ou -1 ou 1"]
[null,"p","Ne font pas partie des limites de la plage.",null,null,null,{"$f":"SUM(IF((OFFSET(B5:B25,COUNT(B5:B25),G1,,1)=\"P\")=TRUE,1))","v":3},"0 = total de \"P\" dans la plage B5:B25"]
["p","p",null,null,null,null,null,"-1 total de P dans la plage \"A5:A25\""]
[null,"p",null,null,null,null,null,"1 total de P dans la plage \"C5:C25"]
[null,"p"]
[null,"p",null,null,null,null,{"$f":"SUMPRODUCT((OFFSET(B5:B25,COUNT(B5:B25),G1,,1)=\"P\")*1)","v":3},"Une autre manière d'écrire la formule"]
[null,"p",null,null,null,null,null,"Ne requiert pas la validation par Maj + Ctrl + Enter"]
["p","p","p"]
["p","p","p"]
["p","p"]
[null,"p"]