{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","SUMIF","Table","Filter1","Filter2","Find & Select","GET.CELL1","GET.CELL2","VBA"],"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":"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":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3],[1,9,1,11]]}
[]
[null,"Using SUMIF Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product","Region","Sales","Color",null,null,null,null,"Product","Region","Sales"]
[null,"Apple","North",2235,"Green",null,null,null,null,"Apple","North",2235]
[null,"Orange","South",1038,"White",null,null,null,null,"Orange","South",1038]
[null,"Apple","North",1719,"Green",null,null,null,null,"Apple","North",1719]
[null,"Banana","East",3807,"White",null,null,null,null,"Banana","East",3807]
[null,"Apple","North",4909,"Green",null,null,null,null,"Apple","North",4909]
[null,"Banana","East",1392,"White",null,null,null,null,"Banana","East",1392]
[null,"Orange","South",3622,"White",null,null,null,null,"Orange","South",3622]
[null,"Total Sales of Apple",null,null,{"$f":"SUMIF(E5:E11,\"Green\",D5:D11)","v":8863}]

{"sheet":"Table","index":2,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2],[13,1,13,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,"Total Sales of Apple",null,{"$f":"SUBTOTAL(109,D5:D9)","v":8863}]
[]
[null,"Do It Yourself"]
[]
[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":"Filter1","index":3,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2],[13,1,13,3]]}
[]
[null,"Utilizing Filter Option to Sum Values of Colored Cells"]
[]
[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 Sales of Apple",null,{"$f":"SUBTOTAL(109,D5:D11)","v":8863}]
[]
[null,"Do It Yourself"]
[]
[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":"Filter2","index":4,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2],[13,1,13,3]]}
[]
[null,"Utilizing Filter Option to Count Colored Cells"]
[]
[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 No. of Cells of Apples",null,{"$f":"SUBTOTAL(103,D5:D11)","v":3}]
[]
[null,"Do It Yourself"]
[]
[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":"Find & Select","index":5,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Incorporating Find & Select Option",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product","Region","Sales",null,null,null,null,null,"Product","Region","Sales"]
[null,"Apple","North",2235,null,null,null,null,null,"Apple","North",2235]
[null,"Orange","South",1038,null,null,null,null,null,"Orange","South",1038]
[null,"Apple","North",1719,null,null,null,null,null,"Apple","North",1719]
[null,"Banana","East",3807,null,null,null,null,null,"Banana","East",3807]
[null,"Apple","North",4909,null,null,null,null,null,"Apple","North",4909]
[null,"Banana","East",1392,null,null,null,null,null,"Banana","East",1392]
[null,"Orange","South",3622,null,null,null,null,null,"Orange","South",3622]

{"sheet":"GET.CELL1","index":6,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,13]]}
[]
[null,"Applying GET.CELL Method to Sum Values of Colored Cells",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product","Region","Sales","Code",null,"Total Sales of Apple",null,null,"Product","Region","Sales",null,"Total Sales of Apple"]
[null,"Apple","North",2235,{"$f":"ClrCode","v":10},null,{"$f":"SUMIF($E$5:$E$11,ClrCode,$D$5:$D$11)","v":8863},null,null,"Apple","North",2235]
[null,"Orange","South",1038,{"$f":"ClrCode","v":0},null,null,null,null,"Orange","South",1038]
[null,"Apple","North",1719,{"$f":"ClrCode","v":10},null,null,null,null,"Apple","North",1719]
[null,"Banana","East",3807,{"$f":"ClrCode","v":0},null,null,null,null,"Banana","East",3807]
[null,"Apple","North",4909,{"$f":"ClrCode","v":10},null,null,null,null,"Apple","North",4909]
[null,"Banana","East",1392,{"$f":"ClrCode","v":0},null,null,null,null,"Banana","East",1392]
[null,"Orange","South",3622,{"$f":"ClrCode","v":0},null,null,null,null,"Orange","South",3622]

{"sheet":"GET.CELL2","index":7,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,13]]}
[]
[null,"Applying GET.CELL Method to Count Colored Cells",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product","Region","Sales","Code",null,"Total Apples",null,null,"Product","Region","Sales",null,"Total Apples"]
[null,"Apple","North",2235,{"$f":"ClrCode","v":10},null,{"$f":"COUNTIF(E5:E11,ClrCode)","v":3},null,null,"Apple","North",2235]
[null,"Orange","South",1038,{"$f":"ClrCode","v":0},null,null,null,null,"Orange","South",1038]
[null,"Apple","North",1719,{"$f":"ClrCode","v":10},null,null,null,null,"Apple","North",1719]
[null,"Banana","East",3807,{"$f":"ClrCode","v":0},null,null,null,null,"Banana","East",3807]
[null,"Apple","North",4909,{"$f":"ClrCode","v":10},null,null,null,null,"Apple","North",4909]
[null,"Banana","East",1392,{"$f":"ClrCode","v":0},null,null,null,null,"Banana","East",1392]
[null,"Orange","South",3622,{"$f":"ClrCode","v":0},null,null,null,null,"Orange","South",3622]

{"sheet":"VBA","index":8,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[12,1,12,2],[13,1,13,2],[1,9,1,11],[12,9,12,10],[13,9,13,10]]}
[]
[null,"Calculating Sum of Colored Cells with VBA",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product","Region","Sales",null,null,null,null,null,"Product","Region","Sales"]
[null,"Apple","North",2235,null,null,null,null,null,"Apple","North",2235]
[null,"Orange","South",1038,null,null,null,null,null,"Orange","South",1038]
[null,"Apple","North",1719,null,null,null,null,null,"Apple","North",1719]
[null,"Banana","East",3807,null,null,null,null,null,"Banana","East",3807]
[null,"Apple","North",4909,null,null,null,null,null,"Apple","North",4909]
[null,"Banana","East",1392,null,null,null,null,null,"Banana","East",1392]
[null,"Orange","South",3622,null,null,null,null,null,"Orange","South",3622]
[]
[null,"Cell Color",null,null,null,null,null,null,null,"Cell Color"]
[null,"Total Sales",null,{"$f":"Sum_Colored_Cells($D$13,$D$5:$D$11)","v":8863},null,null,null,null,null,"Total Sales"]