{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Продажи","Транспорт","Источник","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Продажи","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Город:","Samara",null,{"$f":"IF(C3=Транспорт!C3, \"Значения равны\",\"Значения не равны\")","v":"Значения равны"}]
[]
[null,"Необходимо, чтобы при изменении выбора в списке на листе 2, соответственно менялось значение в списке на листе 1 в ячейке с3"]
[]
[null,null,null,"Продажи"]
[null,null,"Шоколад",{"$f":"IF($C$3=\"All\",SUMIF(Лист3!A$6:A$2000,C8,Лист3!D$6:D$2000),SUMIFS(Лист3!D$6:D$2000,Лист3!A$6:A$2000,C8,Лист3!B$6:B$2000,$C$3))","v":27}]
[null,null,"Морковь",{"$f":"IF($C$3=\"All\",SUMIF(Лист3!A$6:A$2000,C9,Лист3!D$6:D$2000),SUMIFS(Лист3!D$6:D$2000,Лист3!A$6:A$2000,C9,Лист3!B$6:B$2000,$C$3))","v":3}]
[null,null,"Колбаса",{"$f":"IF($C$3=\"All\",SUMIF(Лист3!A$6:A$2000,C10,Лист3!D$6:D$2000),SUMIFS(Лист3!D$6:D$2000,Лист3!A$6:A$2000,C10,Лист3!B$6:B$2000,$C$3))","v":10}]

{"sheet":"Транспорт","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Город:","Samara",null,"работает только \"all\", так как эта позиция выбрана на листе 1"]
[null,null,null,null,"Ключ на листе 3 в Колонке С завязан на лист 1"]
[]
[]
[null,null,"Транспорт"]
[null,"Шоколад",{"$f":"IF($C$3=\"All\",SUMIF(Лист3!A$6:A$2000,B8,Лист3!E$6:E$2000),SUMIFS(Лист3!E$6:E$2000,Лист3!A$6:A$2000,B8,Лист3!B$6:B$2000,$C$3))","v":24}]
[null,"Морковь",{"$f":"IF($C$3=\"All\",SUMIF(Лист3!A$6:A$2000,B9,Лист3!E$6:E$2000),SUMIFS(Лист3!E$6:E$2000,Лист3!A$6:A$2000,B9,Лист3!B$6:B$2000,$C$3))","v":13}]
[null,"Колбаса",{"$f":"IF($C$3=\"All\",SUMIF(Лист3!A$6:A$2000,B10,Лист3!E$6:E$2000),SUMIFS(Лист3!E$6:E$2000,Лист3!A$6:A$2000,B10,Лист3!B$6:B$2000,$C$3))","v":16}]

{"sheet":"Источник","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"All"]
[null,null,null,"Moscow"]
[null,null,null,"St Pete"]
[null,null,null,"Samara"]

{"sheet":"Лист3","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"Продажи","Транспорт"]
["Шоколад","Moscow",null,3,1]
["Шоколад","Moscow",null,15,2]
["Шоколад","Moscow",null,6,3]
["Шоколад","St Pete",null,7,4]
["Шоколад","St Pete",null,9,5]
["Шоколад","St Pete",null,2,6]
["Шоколад","Samara",null,5,7]
["Шоколад","Samara",null,12,8]
["Шоколад","Samara",null,10,9]
["Морковь","Moscow",null,2,11]
["Морковь","St Pete",null,7,12]
["Морковь","Samara",null,3,13]
["Колбаса","Moscow",null,2,14]
["Колбаса","St Pete",null,4,15]
["Колбаса","Samara",null,10,16]