{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":"Лист1","index":0,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,4],[11,0,11,5],[12,0,12,3],[12,4,13,4],[12,5,13,5],[18,0,18,5],[19,0,19,3],[19,4,20,4],[19,5,20,5],[1,0,2,0],[1,1,1,4]]}
["Табл.1 Исходные данные"]
["Сотрудник","Продажи"]
[null,"Дата","Товар","Качество","Сумма"]
["Иванов","2017-01-01","Апельсины","Отличное",1000]
["Сидоров","2016-12-31","Яблоки","Отличное",2000]
["Сидоров","2017-01-01","Яблоки","Отличное",3000]
["Иванов","2016-12-31","Яблоки","Среднее",4000]
["Иванов","2017-01-01","Яблоки","Среднее",5000]
["Сидоров","2016-12-31","Яблоки","Отличное",6000]
[]
[]
["Табл.2 Суммы продаж по условиям (ввод формул вручную)"]
["Условия",null,null,null,"Сумма \nобычной формулой","Сумма\nформулой массива"]
["Сотрудник","Дата","Товар","Качество"]
["Сидоров","2017-01-01","Яблоки","Отличное",{"$f":"SUMIFS($E$4:$E$9,$A$4:$A$9,A15,$B$4:$B$9,B15,$C$4:$C$9,C15,$D$4:$D$9,D15)","v":3000},{"$f":"SUM(IF(($B$4:$B$9=B15)*($C$4:$C$9=C15)*($D$4:$D$9=D15),1)*$E$4:$E$9)","v":3000},{"$f":"SUMPRODUCT(($B$4:$B$9=B15)*($C$4:$C$9=C15)*($D$4:$D$9=D15)*$E$4:$E$9)","v":3000}]
["Сидоров","2016-12-31","Яблоки","Отличное",{"$f":"SUMIFS($E$4:$E$9,$A$4:$A$9,A16,$B$4:$B$9,B16,$C$4:$C$9,C16,$D$4:$D$9,D16)","v":8000},{"$f":"SUM(IF(($B$4:$B$9=B16)*($C$4:$C$9=C16)*($D$4:$D$9=D16),1)*$E$4:$E$9)","v":8000},{"$f":"SUMPRODUCT(($B$4:$B$9=B16)*($C$4:$C$9=C16)*($D$4:$D$9=D16)*$E$4:$E$9)","v":8000}]
[]
[]
["Табл.3 Суммы продаж по условиям (ввод формул VBA)"]
["Условия",null,null,null,"Сумма \nобычной формулой","Сумма\nформулой массива"]
["Сотрудник","Дата","Товар","Качество"]
["Сидоров","2017-01-01","Яблоки","Отличное",{"$f":"SUMIFS($E$4:$E$9,$A$4:$A$9,A22,$B$4:$B$9,B22,$C$4:$C$9,C22,$D$4:$D$9,D22)","v":3000},{"$f":"SUMPRODUCT(($B$4:$B$9=B22)*($C$4:$C$9=C22)*($D$4:$D$9=D22)*$E$4:$E$9)","v":3000},{"$f":"SUMPRODUCT(($B$4:$B$9=B22)*($C$4:$C$9=C22)*($D$4:$D$9=D22)*$E$4:$E$9)","v":3000}]
["Сидоров","2016-12-31","Яблоки","Отличное",8000,8000,{"$f":"SUMPRODUCT(($B$4:$B$9=B23)*($C$4:$C$9=C23)*($D$4:$D$9=D23)*$E$4:$E$9)","v":8000}]