{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ShopRiddle"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"ShopRiddle","index":0,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"магазин",null,674.92]
[null,null,null,null,"Сумма по фильтру:",null,{"$f":"SUBTOTAL(109,G4:G25)","v":52.349094531107767}]
["Вид магазина","Площадь магазина","объем","дата","объем на найбольшую (крайнюю) дату","сумма выбраных обьемов"]
["магазин",85,162.93372308580547,"2012-11-15",null,null,{"$f":"SUMPRODUCT(--($B$4:$B$25=B4)*($D$4:$D$25=SUMPRODUCT((MAX(--(($B$4:$B$25)=B4)*$D$4:$D$25))))*($D$4:$D$25=D4),$C$4:$C$25)","v":0},null,{"$f":"SUMPRODUCT(($B$4:$B$25=B4)*($D$4:$D$25=MAX(($B$4:$B$25=B4)*$D$4:$D$25))*($D$4:$D$25=D4),$C$4:$C$25)","v":0}]
["минимагазин",20,60.691414802295185,"2012-11-16",null,null,{"$f":"SUMPRODUCT(--($B$4:$B$25=B5)*($D$4:$D$25=SUMPRODUCT((MAX(--(($B$4:$B$25)=B5)*$D$4:$D$25))))*($D$4:$D$25=D5),$C$4:$C$25)","v":0},null,{"$f":"SUMPRODUCT(($B$4:$B$25=B5)*($D$4:$D$25=MAX(($B$4:$B$25=B5)*$D$4:$D$25))*($D$4:$D$25=D5),$C$4:$C$25)","v":0}]
["магазин",85,188.88567045876152,"2012-11-17",null,null,0,null,0]
["магазин",105,116.88022122376424,"2012-11-18",{"$f":"C7","v":116.88022122376424},null,116.88022122376424,null,116.88022122376424]
["минимагазин",25,62.016755144595663,"2012-11-19",null,null,0,null,0]
["магазин",85,146.5230065602027,"2012-11-20",null,null,0,null,0]
["магазин",75,188.51618097608207,"2012-11-21",null,null,0,null,0]
["магазин",85,101.69854636261425,"2012-11-22",null,null,0,null,0]
["магазин",50,200.91100493411886,"2012-11-23",null,null,0,null,0]
["магазин",50,113.28472581109145,"2012-11-24",null,null,0,null,0]
["минимагазин",15,59.003797703179771,"2012-11-25",null,null,0,null,0]
["магазин",85,125.41848084004869,"2012-11-26",null,null,0,null,0]
["магазин",85,130.56465415275397,"2012-11-27",null,null,0,null,0]
["магазин",85,196.69524337335201,"2012-11-28",{"$f":"C17","v":196.69524337335201},null,196.69524337335201,null,196.69524337335201]
["минимагазин",10,66.824457144492953,"2012-11-29",null,null,0,null,0]
["минимагазин",15,67.52218242894287,"2012-11-30",{"$f":"C19","v":67.52218242894287},null,67.52218242894287,null,67.52218242894287]
["магазин",75,177.61914479447699,"2012-12-01",{"$f":"C20","v":177.61914479447699},null,177.61914479447699,null,177.61914479447699]
["минимагазин",20,54.516780687461505,"2012-12-02",{"$f":"C21","v":54.516780687461505},null,54.516780687461505,null,54.516780687461505]
["минимагазин",25,80.028391759435181,"2012-12-03",null,null,0,null,0]
["минимагазин",25,63.690062622647019,"2012-12-04",{"$f":"C23","v":63.690062622647019},null,63.690062622647019,null,63.690062622647019]
["магазин",50,183.72106049116337,"2012-12-05",{"$f":"C24","v":183.72106049116337},null,183.72106049116337,null,183.72106049116337]
["минимагазин",10,52.349094531107767,"2012-12-06",{"$f":"C25","v":52.349094531107767},null,52.349094531107767,null,52.349094531107767]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["При выборе ячейки G25 для макроса - получим следующую картину:"]
[]
["СУММПРОИЗВ   <<<   --  (  $B$4:$B$25=B25  )  *  (  $D$4:$D$25=СУММПРОИЗВ  (    (  МАКС  (  --  (    (  $B$4:$B$25  )  =B25  )  *$D$4:$D$25  )    )    )    )  *  (  $D$4:$D$25=D25  )     ...[и]...   $C$4:$C$25   >>>   "]
["   [[...]]   --   <<<   $B$4:$B$25=B25   >>>   *   <<<   $D$4:$D$25=СУММПРОИЗВ  (    (  МАКС  (  --  (    (  $B$4:$B$25  )  =B25  )  *$D$4:$D$25  )    )    )     >>>   *   <<<   $D$4:$D$25=D25   >>>     ;  $C$4:$C$25   [[...]]   "]
["   [[...]]   $B$4:$B$25=B25   [[...]]   $D$4:$D$25=СУММПРОИЗВ   <<<     (  МАКС  (  --  (    (  $B$4:$B$25  )  =B25  )  *$D$4:$D$25  )    )     >>>      [[...]]   $D$4:$D$25=D25   [[...]]   "]
["   [[...]]      <<<   МАКС  (  --  (    (  $B$4:$B$25  )  =B25  )  *$D$4:$D$25  )     >>>      [[...]]   "]
["   [[...]]   МАКС   <<<   --  (    (  $B$4:$B$25  )  =B25  )  *$D$4:$D$25   >>>      [[...]]   "]
["   [[...]]   --   <<<     (  $B$4:$B$25  )  =B25   >>>   *$D$4:$D$25   [[...]]   "]
["   [[...]]      <<<   $B$4:$B$25   >>>   =B25   [[...]]   "]
["   [[...]]   $B$4:$B$25   [[...]]   "]
["   [[...]]   "]