{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset Overview","SUBTOTAL Function","COUNTIF Function","Practice"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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 Overview","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[3,2,3,6]]}
[]
[null,"Dataset Overview"]
[]
[null,null,"Sales Amount"]
[null,"Seller","Jan","Feb","Mar","April","May"]
[null,"Alex",5845,2290,3025,1419,4844]
[null,"John",2344,2223,4753,2029,8408]
[null,"Carry",2280,6811,5760,3126,2341]
[null,"Tom ",2222,9834,6861,8766,2111]
[null,"Paul",1122,3421,7627,9094,9051]
[null,"Simon",988,3320,2552,5193,3880]

{"sheet":"SUBTOTAL Function","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6],[3,2,3,6]]}
[]
[null,"Use of SUBTOTAL Function"]
[]
[null,null,"Sales Amount"]
[null,"Seller","Jan","Feb","Mar","April","May"]
[null,"Alex",5845,2290,3025,1419,4844]
[null,"John",2344,2223,4753,2029,8408]
[null,"Carry",2280,3232,5760,3126,2341]
[null,"Tom ",2222,9834,6861,8766,2111]
[null,"Paul",1122,3421,7627,9094,9051]
[null,"Simon",988,3320,2552,5193,3880]
[]
[null,null,null,"Row 6",{"$f":"SUBTOTAL(102,6:6)","v":5}]
[null,null,null,"Row 8",{"$f":"SUBTOTAL(102,8:8)","v":5}]
[null,null,null,"Row 11",{"$f":"SUBTOTAL(102,11:11)","v":5}]

{"sheet":"COUNTIF Function","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,2,3,5],[4,6,4,9],[1,1,1,9]]}
[]
[null,"Use of GET.CELL & COUNTIF Functions"]
[]
[null,null,"Sales Amount"]
[null,"Seller","Jan","Feb","Mar","April","Color Codes"]
[null,"Alex",5845,5845,5845,5845,{"$f":"ColorCode","v":36},{"$f":"ColorCode","v":36},{"$f":"ColorCode","v":36},{"$f":"ColorCode","v":36}]
[null,"John",2344,2223,4753,2029,{"$f":"ColorCode","v":2},{"$f":"ColorCode","v":2},{"$f":"ColorCode","v":2},{"$f":"ColorCode","v":2}]
[null,"Carry",2280,2280,2280,2280,{"$f":"ColorCode","v":40},{"$f":"ColorCode","v":40},{"$f":"ColorCode","v":40},{"$f":"ColorCode","v":40}]
[null,"Tom ",2222,9834,6861,8766,{"$f":"ColorCode","v":2},{"$f":"ColorCode","v":2},{"$f":"ColorCode","v":2},{"$f":"ColorCode","v":2}]
[null,"Paul",1122,3421,7627,9094,{"$f":"ColorCode","v":2},{"$f":"ColorCode","v":2},{"$f":"ColorCode","v":2},{"$f":"ColorCode","v":2}]
[null,"Simon",988,3320,2552,5193,{"$f":"ColorCode","v":37},{"$f":"ColorCode","v":37},{"$f":"ColorCode","v":37},{"$f":"ColorCode","v":37}]
[]
[null,null,null,null,"Row 6",{"$f":"COUNTIF(G6:J6,36)","v":4},{"$f":"_xlfn.FORMULATEXT(F13)","v":"=COUNTIF(G6:J6,36)"}]
[null,null,null,null,"Row 8",{"$f":"COUNTIF(G8:J8,40)","v":4},{"$f":"_xlfn.FORMULATEXT(F14)","v":"=COUNTIF(G8:J8,40)"}]
[null,null,null,null,"Row 11",{"$f":"COUNTIF(G11:J11,37)","v":4},{"$f":"_xlfn.FORMULATEXT(F15)","v":"=COUNTIF(G11:J11,37)"}]

{"sheet":"Practice","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,6],[3,2,3,6]]}
[]
[null,"Try Yourself"]
[]
[null,null,"Sales Amount"]
[null,"Seller","Jan","Feb","Mar","April","May"]
[null,"Alex",5845,2290,3025,1419,4844]
[null,"John",2344,2223,4753,2029,8408]
[null,"Carry",2280,6811,5760,3126,2341]
[null,"Tom ",2222,9834,6861,8766,2111]
[null,"Paul",1122,3421,7627,9094,9051]
[null,"Simon",988,3320,2552,5193,3880]