{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["sum","+","table","criteria","vba","practice"],"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":"sum","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2]]}
[]
[null,"Use of SUM Function"]
[]
[null,"Month","Product","Sales"]
[null,"January","Cable",2600]
[null,"February","AC",11500]
[null,"March","TV",13500]
[null,"April","Fridge",17000]
[null,"May","Router",20000]
[null,"June","Oven"]
[]
[null,"Running Total",null,{"$f":"SUM(D5:D10)","v":64600}]

{"sheet":"+","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2]]}
[]
[null,"Use of Addition Operator"]
[]
[null,"Month","Product","Sales"]
[null,"January","Cable",2600]
[null,"February","AC",11500]
[null,"March","TV",13500]
[null,"April","Fridge",17000]
[null,"May","Router",18000]
[null,"June","Oven",25000]
[]
[null,"Running Total",null,{"$f":"D5+D6+D7+D8+D9+D10","v":87600}]

{"sheet":"table","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2]]}
[]
[null,"Use of Table Feature"]
[]
[null,"Month","Product","Sales"]
[null,"January","Cable",2600]
[null,"February","AC",11500]
[null,"March","TV",13500]
[null,"April","Fridge",17000]
[null,"May","Router",15000]
[null,"June","Oven",20000]
[]
[null,"Running Total",null,{"$f":"SUM(Table1[Sales])","v":79600}]

{"sheet":"criteria","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2]]}
[]
[null,"Based on Criteria"]
[]
[null,"Month","Product","Sales"]
[null,"January","Cable",2600]
[null,"January","AC",11500]
[null,"February","Cable",13500]
[null,"February","AC",17000]
[null,"March","Cable",10000]
[null,"March","AC"]
[]
[null,"Running Total",null,{"$f":"SUMIF(C5:C10,C5,D5:D10)","v":26100}]

{"sheet":"vba","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[5000]

{"sheet":"practice","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2]]}
[]
[null,"Practice"]
[]
[null,"Month","Product","Sales"]
[null,"January","Cable",2600]
[null,"February","AC",11500]
[null,"March","TV",13500]
[null,"April","Fridge",17000]
[null,"May","Router"]
[null,"June","Oven"]
[]
[null,"Running Total"]