{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Count Values","Filtered","Nested","Hidden","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Count Values","index":0,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,12,1,13],[1,1,1,2]]}
[]
[null,"Counting Items Types",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales (units)",null,null,null,null,null,null,null,null,null,"Items","Sales (units)"]
[null,"Apple",250,null,null,null,null,null,null,null,null,null,"Apple",250]
[null,"Orange",170,null,null,null,null,null,null,null,null,null,"Orange",170]
[null,"Avocado",230,null,null,null,null,null,null,null,null,null,"Avocado",230]
[null,"Banana",330,null,null,null,null,null,null,null,null,null,"Banana",330]
[null,"Beans",150,null,null,null,null,null,null,null,null,null,"Beans",150]
[null,"Total Item Types",{"$f":"SUBTOTAL(3,C5:C9)","v":5},null,null,null,null,null,null,null,null,null,"Total Item Types"]

{"sheet":"Filtered","index":1,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Counting Filtered Data",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales (units)",null,null,null,null,null,null,null,null,null,"Items","Sales (units)"]
[null,"Apple",250,null,null,null,null,null,null,null,null,null,"Apple",250]
[null,"Orange",170,null,null,null,null,null,null,null,null,null,"Orange",170]
[null,"Avocado",230,null,null,null,null,null,null,null,null,null,"Avocado",230]
[null,"Banana",330,null,null,null,null,null,null,null,null,null,"Banana",330]
[null,"Beans",150,null,null,null,null,null,null,null,null,null,"Beans",150]
[null,"Raspberries",240,null,null,null,null,null,null,null,null,null,"Raspberries",240]
[null,"Total Item Types",{"$f":"SUBTOTAL(3,C5:C10)","v":5},null,null,null,null,null,null,null,null,null,"Total Item Types"]

{"sheet":"Nested","index":2,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2],[7,1,7,2],[12,1,12,2],[1,11,1,13],[7,11,7,12],[11,11,11,12],[12,11,12,12]]}
[]
[null,"Counting Nested SUBTOTAL",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Region","Items","Sales (units)",null,null,null,null,null,null,null,"Region","Items","Sales (units)"]
[null,"North","Apple",250,null,null,null,null,null,null,null,"North","Apple",250]
[null,"North","Orange",170,null,null,null,null,null,null,null,"North","Orange",170]
[null,"North","Avocado",230,null,null,null,null,null,null,null,"North","Avocado",230]
[null,"North Total Count",null,{"$f":"SUBTOTAL(3,D5:D7)","v":3},null,null,null,null,null,null,null,"North Total Count"]
[null,"East","Beans",150,null,null,null,null,null,null,null,"East","Beans",150]
[null,"East","Raspberries",240,null,null,null,null,null,null,null,"East","Raspberries",240]
[null,"East","Lemons",150,null,null,null,null,null,null,null,"East","Lemons",150]
[null,"East Total Count",null,{"$f":"SUBTOTAL(3,D9:D11)","v":3},null,null,null,null,null,null,null,"East Total Count"]
[null,"Final Total Count",null,{"$f":"SUBTOTAL(3,D5:D12)","v":6},null,null,null,null,null,null,null,"Final Total Count"]

{"sheet":"Hidden","index":3,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,12,1,13],[1,1,1,2]]}
[]
[null,"Counting Data with Hidden Rows",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales (units)",null,null,null,null,null,null,null,null,null,"Items","Sales (units)"]
[null,"Apple",250,null,null,null,null,null,null,null,null,null,"Apple",250]
[null,"Orange",170,null,null,null,null,null,null,null,null,null,"Orange",170]
[null,"Avocado",230,null,null,null,null,null,null,null,null,null,"Avocado",230]
[null,"Banana",330,null,null,null,null,null,null,null,null,null,"Banana",330]
[null,"Beans",150,null,null,null,null,null,null,null,null,null,"Beans",150]
[null,"Raspberries",240,null,null,null,null,null,null,null,null,null,"Raspberries",240]
[null,"Total Item Types",{"$f":"SUBTOTAL(3,C5:C10)","v":6},null,null,null,null,null,null,null,null,null,"Total Item Types"]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Applying SUBTOTAL in VBA",null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Items","Sales (units)",null,null,null,null,null,null,null,null,null,"Items","Sales (units)"]
[null,"Apple",250,null,null,null,null,null,null,null,null,null,"Apple",250]
[null,"Orange",170,null,null,null,null,null,null,null,null,null,"Orange",170]
[null,"Avocado",230,null,null,null,null,null,null,null,null,null,"Avocado",230]
[null,"Banana",330,null,null,null,null,null,null,null,null,null,"Banana",330]
[null,"Beans",150,null,null,null,null,null,null,null,null,null,"Beans",150]
[null,"Raspberries",240,null,null,null,null,null,null,null,null,null,"Raspberries",240]
[null,"Total Item Types",{"$f":"SUBTOTAL(3,C5:C10)","v":6},null,null,null,null,null,null,null,null,null,"Total Item Types"]