{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Helper","UDF","VBA","Subtotal","GET","Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Dataset","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sum Columns by Color"]
[]
[null,"Item","Sold Quantity"]
[null,"Headphones",200]
[null,"Keyboard",90]
[null,"Mouse",120]
[null,"Headphones",130]
[null,"Keyboard",140]
[null,"Headphones",150]
[null,"Keyboard",100]
[null,"Headphones",170]
[null,"Mouse",180]
[null,"Headphones",150]
[null,"Mouse",90]
[null,"Keyboard",110]

{"sheet":"Helper","index":1,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,6],[1,11,1,12]]}
[]
[null,"Use of SUMIF Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Item","Sold Quantity","Helper",null,"Sum by Color",null,null,null,null,null,"Item","Sold Quantity"]
[null,"Headphones",200,"Blue",null,null,{"$f":"SUMIF(D5:D16,\"Blue\",C5:C16)","v":800},null,null,null,null,"Headphones",200]
[null,"Keyboard",90,"Yellow",null,null,{"$f":"SUMIF(D5:D16,\"Yellow\",C5:C16)","v":440},null,null,null,null,"Keyboard",90]
[null,"Mouse",120,"Green",null,null,{"$f":"SUMIF(D5:D16,\"Green\",C5:C16)","v":390},null,null,null,null,"Mouse",120]
[null,"Headphones",130,"Blue",null,null,null,null,null,null,null,"Headphones",130]
[null,"Keyboard",140,"Yellow",null,null,null,null,null,null,null,"Keyboard",140]
[null,"Headphones",150,"Blue",null,null,null,null,null,null,null,"Headphones",150]
[null,"Keyboard",100,"Yellow",null,null,null,null,null,null,null,"Keyboard",100]
[null,"Headphones",170,"Blue",null,null,null,null,null,null,null,"Headphones",170]
[null,"Mouse",180,"Green",null,null,null,null,null,null,null,"Mouse",180]
[null,"Headphones",150,"Blue",null,null,null,null,null,null,null,"Headphones",150]
[null,"Mouse",90,"Green",null,null,null,null,null,null,null,"Mouse",90]
[null,"Keyboard",110,"Yellow",null,null,null,null,null,null,null,"Keyboard",110]

{"sheet":"UDF","index":2,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,5,3,6],[1,1,1,3],[1,13,1,14]]}
[]
[null,"SUMIF Function & UDF",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Item","Sold Quantity","Color Index",null,"Sum by Color",null,null,null,null,null,null,null,"Item","Sold Quantity"]
[null,"Headphones",200,{"$f":"FindIndex(C5)","v":37},null,null,{"$f":"SUMIF($D$5:$D$16,D5,$C$5:$C$16)","v":800},null,null,null,null,null,null,"Headphones",200]
[null,"Keyboard",90,{"$f":"FindIndex(C6)","v":36},null,null,{"$f":"SUMIF($D$5:$D$16,D6,$C$5:$C$16)","v":440},null,null,null,null,null,null,"Keyboard",90]
[null,"Mouse",120,{"$f":"FindIndex(C7)","v":48},null,null,390,null,null,null,null,null,null,"Mouse",120]
[null,"Headphones",130,{"$f":"FindIndex(C8)","v":37},null,null,null,null,null,null,null,null,null,"Headphones",130]
[null,"Keyboard",140,{"$f":"FindIndex(C9)","v":36},null,null,null,null,null,null,null,null,null,"Keyboard",140]
[null,"Headphones",150,{"$f":"FindIndex(C10)","v":37},null,null,null,null,null,null,null,null,null,"Headphones",150]
[null,"Keyboard",100,{"$f":"FindIndex(C11)","v":36},null,null,null,null,null,null,null,null,null,"Keyboard",100]
[null,"Headphones",170,{"$f":"FindIndex(C12)","v":37},null,null,null,null,null,null,null,null,null,"Headphones",170]
[null,"Mouse",180,{"$f":"FindIndex(C13)","v":48},null,null,null,null,null,null,null,null,null,"Mouse",180]
[null,"Headphones",150,{"$f":"FindIndex(C14)","v":37},null,null,null,null,null,null,null,null,null,"Headphones",150]
[null,"Mouse",90,{"$f":"FindIndex(C15)","v":48},null,null,null,null,null,null,null,null,null,"Mouse",90]
[null,"Keyboard",110,{"$f":"FindIndex(C16)","v":36},null,null,null,null,null,null,null,null,null,"Keyboard",110]

{"sheet":"VBA","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,4,3,5]]}
[]
[null,"Use of VBA"]
[]
[null,"Item","Sold Quantity",null,"Sum by Color"]
[null,"Headphones",200,null,null,{"$f":"SumColor($C$5:$C$16,C5)","v":800}]
[null,"Keyboard",90,null,null,{"$f":"SumColor($C$5:$C$16,C6)","v":440}]
[null,"Mouse",120,null,null,{"$f":"SumColor($C$5:$C$16,C7)","v":390}]
[null,"Headphones",130]
[null,"Keyboard",140]
[null,"Headphones",150]
[null,"Keyboard",100]
[null,"Headphones",170]
[null,"Mouse",180]
[null,"Headphones",150]
[null,"Mouse",90]
[null,"Keyboard",110]

{"sheet":"Subtotal","index":4,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of SUBTOTAL Function & Filter"]
[]
[null,"Item","Sold Quantity"]
[null,"Headphones",200]
[null,"Keyboard",90]
[null,"Mouse",120]
[null,"Headphones",130]
[null,"Keyboard",140]
[null,"Headphones",150]
[null,"Keyboard",100]
[null,"Headphones",170]
[null,"Mouse",180]
[null,"Headphones",150]
[null,"Mouse",90]
[null,"Keyboard",110]
[]
[null,"Sum by Color",{"$f":"SUBTOTAL(9,C5:C16)","v":1630}]

{"sheet":"GET","index":5,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,6],[1,12,1,13]]}
[]
[null,"Use of GET.CELL Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Item","Sold Quantity","Color Index",null,"Sum by Color",null,null,null,null,null,null,"Item","Sold Quantity"]
[null,"Headphones",200,{"$f":"Color_Index","v":37},null,null,{"$f":"SUMIF($D$5:$D$16,D5,$C$5:$C$16)","v":800},null,null,null,null,null,"Headphones",200]
[null,"Keyboard",90,{"$f":"Color_Index","v":36},null,null,{"$f":"SUMIF($D$5:$D$16,D6,$C$5:$C$16)","v":440},null,null,null,null,null,"Keyboard",90]
[null,"Mouse",120,{"$f":"Color_Index","v":50},null,null,{"$f":"SUMIF($D$5:$D$16,D7,$C$5:$C$16)","v":390},null,null,null,null,null,"Mouse",120]
[null,"Headphones",130,{"$f":"Color_Index","v":37},null,null,null,null,null,null,null,null,"Headphones",130]
[null,"Keyboard",140,{"$f":"Color_Index","v":36},null,null,null,null,null,null,null,null,"Keyboard",140]
[null,"Headphones",150,{"$f":"Color_Index","v":37},null,null,null,null,null,null,null,null,"Headphones",150]
[null,"Keyboard",100,{"$f":"Color_Index","v":36},null,null,null,null,null,null,null,null,"Keyboard",100]
[null,"Headphones",170,{"$f":"Color_Index","v":37},null,null,null,null,null,null,null,null,"Headphones",170]
[null,"Mouse",180,{"$f":"Color_Index","v":50},null,null,null,null,null,null,null,null,"Mouse",180]
[null,"Headphones",150,{"$f":"Color_Index","v":37},null,null,null,null,null,null,null,null,"Headphones",150]
[null,"Mouse",90,{"$f":"Color_Index","v":50},null,null,null,null,null,null,null,null,"Mouse",90]
[null,"Keyboard",110,{"$f":"Color_Index","v":36},null,null,null,null,null,null,null,null,"Keyboard",110]

{"sheet":"Table","index":6,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Table Design"]
[]
[null,"Item","Sold Quantity"]
[null,"Headphones",200]
[null,"Keyboard",90]
[null,"Mouse",120]
[null,"Headphones",130]
[null,"Keyboard",140]
[null,"Headphones",150]
[null,"Keyboard",100]
[null,"Headphones",170]
[null,"Mouse",180]
[null,"Headphones",150]
[null,"Mouse",90]
[null,"Keyboard",110]
[null,"Total",{"$f":"SUBTOTAL(109,Table1[Sold Quantity])","v":1630}]