{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Main Dataset","SUMIF","Table","Filter","Filter1","Find & Select","SUM","Count","Practice"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Main Dataset","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"X\" Company"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",2235]
[null,"Orange","South",1038]
[null,"Apple","North",1719]
[null,"Banana","East",3807]
[null,"Apple","North",4909]
[null,"Banana","East",1392]
[null,"Orange","South",3622]

{"sheet":"SUMIF","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using SUMIF function"]
[]
[null,"Product","Region","Sales","Color"]
[null,"Apple","North",2235,"Green"]
[null,"Orange","South",1038,"White"]
[null,"Apple","North",1719,"Green"]
[null,"Banana","East",3807,"White"]
[null,"Apple","North",4909,"Green"]
[null,"Banana","East",1392,"White"]
[null,"Orange","South",3622,"White"]
[null,null,"Total Sales of Apple",{"$f":"SUMIF(E5:E11,\"Green\",D5:D11)","v":8863}]

{"sheet":"Table","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Creating Table"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",2235]
[null,"Orange","South",1038]
[null,"Apple","North",1719]
[null,"Banana","East",3807]
[null,"Apple","North",4909]
[null,"Banana","East",1392]
[null,"Orange","South",3622]
[null,null,"Total Sales of Apple",{"$f":"SUBTOTAL(109,D5:D9)","v":8863}]

{"sheet":"Filter","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Filter Option"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",2235]
[null,"Orange","South",1038]
[null,"Apple","North",1719]
[null,"Banana","East",3807]
[null,"Apple","North",4909]
[null,"Banana","East",1392]
[null,"Orange","South",3622]
[null,null,"Total Sales of Apple",{"$f":"SUBTOTAL(109,D5:D11)","v":8863}]

{"sheet":"Filter1","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Filter Option"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",2235]
[null,"Orange","South",1038]
[null,"Apple","North",1719]
[null,"Banana","East",3807]
[null,"Apple","North",4909]
[null,"Banana","East",1392]
[null,"Orange","South",3622]
[null,"Total Apples",{"$f":"SUBTOTAL(103,B5:B11)","v":3}]

{"sheet":"Find & Select","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Find & Select Option"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",2235]
[null,"Orange","South",1038]
[null,"Apple","North",1719]
[null,"Banana","East",3807]
[null,"Apple","North",4909]
[null,"Banana","East",1392]
[null,"Orange","South",3622]

{"sheet":"SUM","index":6,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using GET.CELL"]
[]
[null,"Product","Region","Sales","Code"]
[null,"Apple","North",2235,{"$f":"ClrCode","v":10},"Total Sales of Apple",{"$f":"SUMIF(E5:E11,ClrCode,D5:D11)","v":8863}]
[null,"Orange","South",1038,{"$f":"ClrCode","v":0}]
[null,"Apple","North",1719,{"$f":"ClrCode","v":10}]
[null,"Banana","East",3807,{"$f":"ClrCode","v":0}]
[null,"Apple","North",4909,{"$f":"ClrCode","v":10}]
[null,"Banana","East",1392,{"$f":"ClrCode","v":0}]
[null,"Orange","South",3622,{"$f":"ClrCode","v":0}]

{"sheet":"Count","index":7,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using GET.CELL"]
[]
[null,"Product","Region","Sales","Code"]
[null,"Apple","North",2235,{"$f":"ClrCode","v":10},"Total Apples",{"$f":"COUNTIF(E5:E11,ClrCode)","v":3}]
[null,"Orange","South",1038,{"$f":"ClrCode","v":0}]
[null,"Apple","North",1719,{"$f":"ClrCode","v":10}]
[null,"Banana","East",3807,{"$f":"ClrCode","v":0}]
[null,"Apple","North",4909,{"$f":"ClrCode","v":10}]
[null,"Banana","East",1392,{"$f":"ClrCode","v":0}]
[null,"Orange","South",3622,{"$f":"ClrCode","v":0}]

{"sheet":"Practice","index":8,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","North",2235]
[null,"Orange","South",1038]
[null,"Apple","North",1719]
[null,"Banana","East",3807]
[null,"Apple","North",4909]
[null,"Banana","East",1392]
[null,"Orange","South",3622]
[null,null,"Total Sales of Apple"]