{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Январь","Февраль","Март","Апрель","Май","Итоги"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Январь","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Наименование","Кол-во","Стоимость","Сумма"]
["Апельсин",15,150,2250]
["Банан",13,237,3081]
["Ананас",25,139,3475]
["Мандарин",45,133,5985]
["Яблоко",24,212,5088]
[null,null,"Итого:",{"$f":"SUM(D2:D6)","v":19879}]

{"sheet":"Февраль","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Наименование","Кол-во","Стоимость","Сумма"]
["Ананас",32,156,4992]
["Банан",56,232,12992]
["Яблоко",45,132,5940]
["Апельсин",15,167,2505]
["Мандарин",26,144,3744]
[null,null,"Итого:",{"$f":"SUM(D2:D6)","v":30173}]

{"sheet":"Март","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Наименование","Кол-во","Стоимость","Сумма"]
["Апельсин",5,132,660]
["Ананас",54,226,12204]
["Банан",38,143,5434]
["Яблоко",8,211,1688]
["Мандарин",35,219,7665]
[null,null,"Итого:",{"$f":"SUM(D2:D6)","v":27651}]

{"sheet":"Апрель","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Наименование","Кол-во","Стоимость","Сумма"]
["Апельсин",15,150,2250]
["Банан",13,237,3081]
["Ананас",25,139,3475]
["Мандарин",45,133,5985]
["Яблоко",24,212,5088]
[null,null,"Итого:",{"$f":"SUM(D2:D6)","v":19879}]

{"sheet":"Май","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Наименование","Кол-во","Стоимость","Сумма"]
["Апельсин",15,150,2250]
["Мандарин",45,133,5985]
["Банан",13,237,3081]
["Ананас",25,139,3475]
["Яблоко",24,212,5088]
[null,null,"Итого:",{"$f":"SUM(D2:D6)","v":19879}]

{"sheet":"Итоги","index":5,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"Со всех листов","Только до листа с функцией"]
["Функция с трехмерной ссылкой",{"$f":"SUM(Январь:Май!D7)","v":117461},{"$f":"SUM(Январь:Март!D7)","v":77703}]
[]
["Функция All_SumIf","Только с определенных листов","Листы для суммирования"]
["Ананас",{"$f":"All_Sumif($A$3:$A$6,Итоги!$A5,$D$2:$D$6,C5)","v":{"$error":"#VALUE!"}},null,"все листы кроме активного (если не указано ни одного)"]
["Банан",{"$f":"All_Sumif($A$3:$A$6,Итоги!$A6,$D$2:$D$6,C6)","v":{"$error":"#VALUE!"}},"Февраль?Март","указанные листы"]