{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["subtotal","sumif","sumifs","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":"subtotal","index":0,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12],[11,1,11,2],[12,1,12,2]]}
[]
[null,"Use of SUBTOTAL Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales",null,60100,null,null,null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","Cable",2600,null,null,null,null,null,null,"Wilham","Cable",2600]
[null,"Simon","AC",11500,null,null,null,null,null,null,"Simon","AC",11500]
[null,"Frank","TV",13500,null,null,null,null,null,null,"Frank","TV",13500]
[null,"Nathan","Fridge",17000,null,null,null,null,null,null,"Nathan","Fridge",17000]
[null,"Jaxson","Router",5500,null,null,null,null,null,null,"Jaxson","Router",5500]
[null,"Anthony","Oven",10000,null,null,null,null,null,null,"Anthony","Oven",10000]
[]
[null,"Total",null,{"$f":"SUBTOTAL(9,D5:D10)","v":38500}]
[null,"Percentage",null,{"$f":"D12/F4","v":0.6405990016638935}]

{"sheet":"sumif","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,13,2],[13,3,13,4],[1,1,1,3],[1,10,1,12],[11,1,11,2],[12,1,12,2],[11,3,11,4],[12,3,12,4]]}
[]
[null,"Use of SUMIF Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales","Color Code",null,null,null,null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","Cable",2600,{"$f":"ColoredNumber","v":0},null,null,null,null,null,"Wilham","Cable",2600]
[null,"Simon","AC",11500,{"$f":"ColoredNumber","v":0},null,null,null,null,null,"Simon","AC",11500]
[null,"Frank","TV",13500,{"$f":"ColoredNumber","v":0},null,null,null,null,null,"Frank","TV",13500]
[null,"Nathan","Fridge",17000,{"$f":"ColoredNumber","v":2},null,null,null,null,null,"Nathan","Fridge",17000]
[null,"Jaxson","Router",5500,{"$f":"ColoredNumber","v":0},null,null,null,null,null,"Jaxson","Router",5500]
[null,"Anthony","Oven",10000,{"$f":"ColoredNumber","v":2},null,null,null,null,null,"Anthony","Oven",10000]
[]
[null,"Total",null,{"$f":"SUM(D5:D10)","v":60100}]
[null,"Colored Number Total",null,{"$f":"SUMIF(E5:E10,E8,D5:D10)","v":27000}]
[null,"Percentage",null,{"$f":"D13/D12","v":0.4492512479201331}]

{"sheet":"sumifs","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,13,2],[13,3,13,4],[1,1,1,3],[1,6,1,8],[11,1,11,2],[11,3,11,4],[12,1,12,2],[12,3,12,4]]}
[]
[null,"Use of SUMIFS Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales","Color Code",null,"Salesman","Product","Net Sales"]
[null,"Wilham","Cable",2600,{"$f":"ColorCode","v":0},null,"Wilham","Cable",2600]
[null,"Simon","AC",11500,{"$f":"ColorCode","v":44},null,"Simon","AC",11500]
[null,"Frank","TV",13500,{"$f":"ColorCode","v":44},null,"Frank","TV",13500]
[null,"Nathan","Fridge",17000,{"$f":"ColorCode","v":44},null,"Nathan","Fridge",17000]
[null,"Jaxson","Router",5500,{"$f":"ColorCode","v":0},null,"Jaxson","Router",5500]
[null,"Anthony","Oven",10000,{"$f":"ColorCode","v":0},null,"Anthony","Oven",10000]
[]
[null,"Total",null,{"$f":"SUM(D5:D10)","v":60100}]
[null,"Colored Number Total",null,{"$f":"SUMIFS(D5:D10,E5:E10,E6)","v":42000}]
[null,"Percentage",null,{"$f":"D13/D12","v":0.69883527454242933}]

{"sheet":"vba","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[]
[null,"VBA Method",null,null,null,null,"Practice Yourself"]
[]
[null,"Salesman","Product","Net Sales",null,null,"Salesman","Product","Net Sales"]
[null,"Wilham","Cable",2600,null,null,"Wilham","Cable",2600]
[null,"Simon","AC",11500,null,null,"Simon","AC",11500]
[null,"Frank","TV",13500,null,null,"Frank","TV",13500]
[null,"Nathan","Fridge",17000,null,null,"Nathan","Fridge",17000]
[null,"Jaxson","Router",5500,null,null,"Jaxson","Router",5500]
[null,"Anthony","Oven",10000,null,null,"Anthony","Oven",10000]
[]
[null,"Total",null,{"$f":"SUM(D5:D11)","v":60100}]
[null,"Colored Number Total",null,{"$f":"ColorTotal(D5,D5:D10)","v":16100}]
[null,"Percentage",null,{"$f":"D13/D12","v":0.26788685524126454}]