{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Pivot table","Array formula"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Data","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["#id","Date","Consumer","Product","Price"]
[{"$f":"ROW(A1)","v":1},"2011-04-06","Rhett Barfield","A",74]
[{"$f":"ROW(A2)","v":2},"2011-05-03","Giverny Meyer","B",54]
[3,"2011-01-17","Zechariah Hardesty","C",85]
[4,"2011-10-19","Edmund Dallas","D",83]
[5,"2011-05-03","Giverny Meyer","A",36]
[6,"2011-12-21","Nafuna Meehan","D",66]
[7,"2011-11-30","Wyatt Kruger","E",26]
[8,"2011-04-06","Rhett Barfield","F",2]
[9,"2011-04-06","Rhett Barfield","G",73]
[10,"2011-05-03","Giverny Meyer","H",46]
[11,"2011-11-19","Anjali Carbone","I",30]
[12,"2011-06-25","Rowena Autry","J",97]
[13,"2011-03-24","Houston Collazo","K",93]
[14,"2011-09-02","Giverny Meyer","L",28]
[15,"2011-07-15","Jonah Trinidad","M",1]
[16,"2011-03-11","Ezequiel Hills","N",47]
[17,"2011-01-17","Zechariah Hardesty","O",67]
[18,"2011-01-17","Zechariah Hardesty","P",27]
[19,"2011-07-11","Aryan Valadez","Q",59]
[20,"2011-01-17","Zechariah Hardesty","R",15]

{"sheet":"Pivot table","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Values"]
["Row Labels","Sum of Price","Count of #id"]
["Anjali Carbone",30,1]
["Aryan Valadez",59,1]
["Edmund Dallas",83,1]
["Ezequiel Hills",47,1]
["Giverny Meyer",164,4]
["Houston Collazo",93,1]
["Jonah Trinidad",1,1]
["Nafuna Meehan",66,1]
["Rhett Barfield",149,3]
["Rowena Autry",97,1]
["Wyatt Kruger",26,1]
["Zechariah Hardesty",194,4]
["Grand Total",1009,20]

{"sheet":"Array formula","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Date","Consumer","Items","Price"]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B1,Data!$C$2:$C$21,$A$1:A1,Data!$B$2:$B$21),0),COLUMN(A1))","v":"2011-04-06"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C1,Data!$C$2:$C$21,$A$1:B1,Data!$B$2:$B$21),0),COLUMN(B1))","v":"Rhett Barfield"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B2,Data!$B$2:$B$21,A2)","v":3},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B2,Data!$B$2:$B$21,A2)","v":149}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B2,Data!$C$2:$C$21,$A$1:A2,Data!$B$2:$B$21),0),COLUMN(A2))","v":"2011-05-03"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C2,Data!$C$2:$C$21,$A$1:B2,Data!$B$2:$B$21),0),COLUMN(B2))","v":"Giverny Meyer"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B3,Data!$B$2:$B$21,A3)","v":3},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B3,Data!$B$2:$B$21,A3)","v":136}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B3,Data!$C$2:$C$21,$A$1:A3,Data!$B$2:$B$21),0),COLUMN(A3))","v":"2011-01-17"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C3,Data!$C$2:$C$21,$A$1:B3,Data!$B$2:$B$21),0),COLUMN(B3))","v":"Zechariah Hardesty"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B4,Data!$B$2:$B$21,A4)","v":4},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B4,Data!$B$2:$B$21,A4)","v":194}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B4,Data!$C$2:$C$21,$A$1:A4,Data!$B$2:$B$21),0),COLUMN(A4))","v":"2011-10-19"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C4,Data!$C$2:$C$21,$A$1:B4,Data!$B$2:$B$21),0),COLUMN(B4))","v":"Edmund Dallas"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B5,Data!$B$2:$B$21,A5)","v":1},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B5,Data!$B$2:$B$21,A5)","v":83}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B5,Data!$C$2:$C$21,$A$1:A5,Data!$B$2:$B$21),0),COLUMN(A5))","v":"2011-12-21"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C5,Data!$C$2:$C$21,$A$1:B5,Data!$B$2:$B$21),0),COLUMN(B5))","v":"Nafuna Meehan"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B6,Data!$B$2:$B$21,A6)","v":1},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B6,Data!$B$2:$B$21,A6)","v":66}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B6,Data!$C$2:$C$21,$A$1:A6,Data!$B$2:$B$21),0),COLUMN(A6))","v":"2011-11-30"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C6,Data!$C$2:$C$21,$A$1:B6,Data!$B$2:$B$21),0),COLUMN(B6))","v":"Wyatt Kruger"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B7,Data!$B$2:$B$21,A7)","v":1},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B7,Data!$B$2:$B$21,A7)","v":26}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B7,Data!$C$2:$C$21,$A$1:A7,Data!$B$2:$B$21),0),COLUMN(A7))","v":"2011-11-19"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C7,Data!$C$2:$C$21,$A$1:B7,Data!$B$2:$B$21),0),COLUMN(B7))","v":"Anjali Carbone"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B8,Data!$B$2:$B$21,A8)","v":1},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B8,Data!$B$2:$B$21,A8)","v":30}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B8,Data!$C$2:$C$21,$A$1:A8,Data!$B$2:$B$21),0),COLUMN(A8))","v":"2011-06-25"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C8,Data!$C$2:$C$21,$A$1:B8,Data!$B$2:$B$21),0),COLUMN(B8))","v":"Rowena Autry"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B9,Data!$B$2:$B$21,A9)","v":1},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B9,Data!$B$2:$B$21,A9)","v":97}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B9,Data!$C$2:$C$21,$A$1:A9,Data!$B$2:$B$21),0),COLUMN(A9))","v":"2011-03-24"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C9,Data!$C$2:$C$21,$A$1:B9,Data!$B$2:$B$21),0),COLUMN(B9))","v":"Houston Collazo"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B10,Data!$B$2:$B$21,A10)","v":1},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B10,Data!$B$2:$B$21,A10)","v":93}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B10,Data!$C$2:$C$21,$A$1:A10,Data!$B$2:$B$21),0),COLUMN(A10))","v":"2011-09-02"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C10,Data!$C$2:$C$21,$A$1:B10,Data!$B$2:$B$21),0),COLUMN(B10))","v":"Giverny Meyer"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B11,Data!$B$2:$B$21,A11)","v":1},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B11,Data!$B$2:$B$21,A11)","v":28}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B11,Data!$C$2:$C$21,$A$1:A11,Data!$B$2:$B$21),0),COLUMN(A11))","v":"2011-07-15"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C11,Data!$C$2:$C$21,$A$1:B11,Data!$B$2:$B$21),0),COLUMN(B11))","v":"Jonah Trinidad"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B12,Data!$B$2:$B$21,A12)","v":1},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B12,Data!$B$2:$B$21,A12)","v":1}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B12,Data!$C$2:$C$21,$A$1:A12,Data!$B$2:$B$21),0),COLUMN(A12))","v":"2011-03-11"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C12,Data!$C$2:$C$21,$A$1:B12,Data!$B$2:$B$21),0),COLUMN(B12))","v":"Ezequiel Hills"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B13,Data!$B$2:$B$21,A13)","v":1},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B13,Data!$B$2:$B$21,A13)","v":47}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B13,Data!$C$2:$C$21,$A$1:A13,Data!$B$2:$B$21),0),COLUMN(A13))","v":"2011-07-11"},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C13,Data!$C$2:$C$21,$A$1:B13,Data!$B$2:$B$21),0),COLUMN(B13))","v":"Aryan Valadez"},{"$f":"COUNTIFS(Data!$C$2:$C$21,B14,Data!$B$2:$B$21,A14)","v":1},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B14,Data!$B$2:$B$21,A14)","v":59}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B14,Data!$C$2:$C$21,$A$1:A14,Data!$B$2:$B$21),0),COLUMN(A14))","v":{"$error":"#N/A"}},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C14,Data!$C$2:$C$21,$A$1:B14,Data!$B$2:$B$21),0),COLUMN(B14))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(Data!$C$2:$C$21,B15,Data!$B$2:$B$21,A15)","v":0},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B15,Data!$B$2:$B$21,A15)","v":0}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B15,Data!$C$2:$C$21,$A$1:A15,Data!$B$2:$B$21),0),COLUMN(A15))","v":{"$error":"#N/A"}},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C15,Data!$C$2:$C$21,$A$1:B15,Data!$B$2:$B$21),0),COLUMN(B15))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(Data!$C$2:$C$21,B16,Data!$B$2:$B$21,A16)","v":0},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B16,Data!$B$2:$B$21,A16)","v":0}]
[{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:B16,Data!$C$2:$C$21,$A$1:A16,Data!$B$2:$B$21),0),COLUMN(A16))","v":{"$error":"#N/A"}},{"$f":"INDEX(Data!$B$2:$C$21,MATCH(0,COUNTIFS($B$1:C16,Data!$C$2:$C$21,$A$1:B16,Data!$B$2:$B$21),0),COLUMN(B16))","v":{"$error":"#N/A"}},{"$f":"COUNTIFS(Data!$C$2:$C$21,B17,Data!$B$2:$B$21,A17)","v":0},{"$f":"SUMIFS(Data!$E$2:$E$21,Data!$C$2:$C$21,B17,Data!$B$2:$B$21,A17)","v":0}]