{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","SingleColumn","MultiColumn","Non-Contiguous","AutoSum","StatusBar","Manual","Subtotal","Aggregate","ExcelTable","VBA","SUMIF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset Overview"]
[]
[null,"Emoloyee","January","February","March"]
[null,"Alex",1200,1100,1300]
[null,"John",1300,1500,2000]
[null,"Tom",1400,1400,1300]
[null,"Carry",1200,1600,1100]
[null,"Sam",1500,1300,1000]

{"sheet":"SingleColumn","index":1,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"For Single Column",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Emoloyee","January","February","March",null,null,null,null,null,"Emoloyee","January","February","March"]
[null,"Alex",1200,1100,1300,null,null,null,null,null,"Alex",1200,1100,1300]
[null,"John",1300,1500,2000,null,null,null,null,null,"John",1300,1500,2000]
[null,"Tom",1400,1400,1300,null,null,null,null,null,"Tom",1400,1400,1300]
[null,"Carry",1200,1600,1100,null,null,null,null,null,"Carry",1200,1600,1100]
[null,"Sam",1500,1300,1000,null,null,null,null,null,"Sam",1500,1300,1000]
[]
[null,"Sum of Column D",{"$f":"SUM(D:D)","v":6900}]

{"sheet":"MultiColumn","index":2,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"For Multiple Columns",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Emoloyee","January","February","March",null,null,null,null,null,"Emoloyee","January","February","March"]
[null,"Alex",1200,1100,1300,null,null,null,null,null,"Alex",1200,1100,1300]
[null,"John",1300,1500,2000,null,null,null,null,null,"John",1300,1500,2000]
[null,"Tom",1400,1400,1300,null,null,null,null,null,"Tom",1400,1400,1300]
[null,"Carry",1200,1600,1100,null,null,null,null,null,"Carry",1200,1600,1100]
[null,"Sam",1500,1300,1000,null,null,null,null,null,"Sam",1500,1300,1000]
[]
[" ","Sum of Column D & E",{"$f":"SUM(D:E)","v":13600}]

{"sheet":"Non-Contiguous","index":3,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Non-Contiguous Column",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Emoloyee","January","February","March",null,null,null,"Emoloyee","January","February","March"]
[null,"Alex",1200,1100,1300,null,null,null,"Alex",1200,1100,1300]
[null,"John",1300,1500,2000,null,null,null,"John",1300,1500,2000]
[null,"Tom",1400,1400,1300,null,null,null,"Tom",1400,1400,1300]
[null,"Carry",1200,1600,1100,null,null,null,"Carry",1200,1600,1100]
[null,"Sam",1500,1300,1000,null,null,null,"Sam",1500,1300,1000]
[]
[null,"Sum of Column C & E",null,{"$f":"SUM(SUM(C:C),SUM(E:E))","v":13300},null,null,null,null,"Sum of Column C & E"]

{"sheet":"AutoSum","index":4,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of AutoSum",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Emoloyee","January","February","March",null,null,null,null,null,"Emoloyee","January","February","March"]
[null,"Alex",1200,1100,1300,null,null,null,null,null,"Alex",1200,1100,1300]
[null,"John",1300,1500,2000,null,null,null,null,null,"John",1300,1500,2000]
[null,"Tom",1400,1400,1300,null,null,null,null,null,"Tom",1400,1400,1300]
[null,"Carry",1200,1600,1100,null,null,null,null,null,"Carry",1200,1600,1100]
[null,"Sam",1500,1300,1000,null,null,null,null,null,"Sam",1500,1300,1000]
[null,"Total",{"$f":"SUM(C5:C9)","v":6600},{"$f":"SUM(D5:D9)","v":6900},{"$f":"SUM(E5:E9)","v":6700},null,null,null,null,null,"Total"]

{"sheet":"StatusBar","index":5,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of Status Bar",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Emoloyee","January","February","March",null,null,null,null,null,"Emoloyee","January","February","March"]
[null,"Alex",1200,1100,1300,null,null,null,null,null,"Alex",1200,1100,1300]
[null,"John",1300,1500,2000,null,null,null,null,null,"John",1300,1500,2000]
[null,"Tom",1400,1400,1300,null,null,null,null,null,"Tom",1400,1400,1300]
[null,"Carry",1200,1600,1100,null,null,null,null,null,"Carry",1200,1600,1100]
[null,"Sam",1500,1300,1000,null,null,null,null,null,"Sam",1500,1300,1000]

{"sheet":"Manual","index":6,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Insert of SUM Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Emoloyee","January","February","March",null,null,null,null,null,"Emoloyee","January","February","March"]
[null,"Alex",1200,1100,1300,null,null,null,null,null,"Alex",1200,1100,1300]
[null,"John",1300,1500,2000,null,null,null,null,null,"John",1300,1500,2000]
[null,"Tom",1400,1400,1300,null,null,null,null,null,"Tom",1400,1400,1300]
[null,"Carry",1200,1600,1100,null,null,null,null,null,"Carry",1200,1600,1100]
[null,"Sam",1500,1300,1000,null,null,null,null,null,"Sam",1500,1300,1000]
[null,"Total",{"$f":"SUM(C5:C9)","v":6600},{"$f":"SUM(D5:D9)","v":6900},6700,null,null,null,null,null,"Total"]

{"sheet":"Subtotal","index":7,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of SUBTOTAL Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Emoloyee","January","February","March",null,null,null,null,null,"Emoloyee","January","February","March"]
[null,"Alex",1200,1100,1300,null,null,null,null,null,"Alex",1200,1100,1300]
[null,"John",1300,1500,2000,null,null,null,null,null,"John",1300,1500,2000]
[null,"Tom",1400,1400,1300,null,null,null,null,null,"Tom",1400,1400,1300]
[null,"Carry",1200,1600,1100,null,null,null,null,null,"Carry",1200,1600,1100]
[null,"Sam",1500,1300,1000,null,null,null,null,null,"Sam",1500,1300,1000]
[null,"Total",{"$f":"SUBTOTAL(9,C5:C9)","v":6600},{"$f":"SUBTOTAL(9,D5:D9)","v":6900},6700,null,null,null,null,null,"Total"]

{"sheet":"Aggregate","index":8,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of AGGREGATE Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Emoloyee","January","February","March",null,null,null,null,null,"Emoloyee","January","February","March"]
[null,"Alex",1200,1100,1300,null,null,null,null,null,"Alex",1200,1100,1300]
[null,"John",1300,1500,2000,null,null,null,null,null,"John",1300,1500,2000]
[null,"Tom",1400,1400,1300,null,null,null,null,null,"Tom",1400,1400,1300]
[null,"Carry",1200,1600,1100,null,null,null,null,null,"Carry",1200,1600,1100]
[null,"Sam",1500,1300,1000,null,null,null,null,null,"Sam",1500,1300,1000]
[null,"Total",{"$f":"_xlfn.AGGREGATE(9,5,C5:C9)","v":6600},{"$f":"_xlfn.AGGREGATE(9,5,D5:D9)","v":6900},6700,null,null,null,null,null,"Total"]

{"sheet":"ExcelTable","index":9,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"With Excel Table",null,null,null,null,null,null,null,null,"With Excel Table"]
[]
[null,"Emoloyee","January","February","March",null,null,null,null,null,"Emoloyee","January","February","March"]
[null,"Alex",1200,1100,1300,null,null,null,null,null,"Alex",1200,1100,1300]
[null,"John",1300,1500,2000,null,null,null,null,null,"John",1300,1500,2000]
[null,"Tom",1400,1400,1300,null,null,null,null,null,"Tom",1400,1400,1300]
[null,"Carry",1200,1600,1100,null,null,null,null,null,"Carry",1200,1600,1100]
[null,"Sam",1500,1300,1000,null,null,null,null,null,"Sam",1500,1300,1000]
[null,"Total",null,{"$f":"SUBTOTAL(109,Table1[February])","v":6900},{"$f":"SUBTOTAL(109,Table1[March])","v":6700}]

{"sheet":"VBA","index":10,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"With VBA",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Emoloyee","January","February","March",null,null,null,null,null,"Emoloyee","January","February","March"]
[null,"Alex",1200,1100,1300,null,null,null,null,null,"Alex",1200,1100,1300]
[null,"John",1300,1500,2000,null,null,null,null,null,"John",1300,1500,2000]
[null,"Tom",1400,1400,1300,null,null,null,null,null,"Tom",1400,1400,1300]
[null,"Carry",1200,1600,1100,null,null,null,null,null,"Carry",1200,1600,1100]
[null,"Sam",1500,1300,1000,null,null,null,null,null,"Sam",1500,1300,1000]
[]
[null,"Sum of Column E",{"$f":"SUMENTIRE(E:E)","v":6700}]

{"sheet":"SUMIF","index":11,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use of SUMIF Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Emoloyee","January",null,null,null,null,null,null,null,"Emoloyee","January"]
[null,"Alex",1200,null,null,null,null,null,null,null,"Alex",1200]
[null,"John",1300,null,null,null,null,null,null,null,"John",1300]
[null,"Tom",1400,null,null,null,null,null,null,null,"Tom",1400]
[null,"Carry",1200,null,null,null,null,null,null,null,"Carry",1200]
[null,"Sam",1500,null,null,null,null,null,null,null,"Sam",1500]
[null,null,{"$f":"SUMIF(C5:C9,\">1200\",C5:C9)","v":4200}]