{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["COUNTIF Function Method","SUMPRODUCT Function Method","Pivot Table Method","Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"COUNTIF Function Method","index":0,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,13,1,14]]}
[]
[null,"Use of COUNTIF Function",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Order Date",null,null,null,null,null,null,null,null,null,null,"Product Name","Order Date"]
[null,"Watch","2021-08-11",null,"Date","Occurrence",null,null,null,null,null,null,null,"Watch","2021-08-11"]
[null,"Hat","2021-10-10",null,"2021-10-10",{"$f":"COUNTIF(C5:C12,E6)","v":3},null,null,null,null,null,null,null,"Hat","2021-10-10"]
[null,"Shirt","2021-08-11",null,null,null,null,null,null,null,null,null,null,"Shirt","2021-08-11"]
[null,"Sunglass","2021-05-11",null,null,null,null,null,null,null,null,null,null,"Sunglass","2021-05-11"]
[null,"Shoe","2021-08-11",null,null,null,null,null,null,null,null,null,null,"Shoe","2021-08-11"]
[null,"Trimmer","2021-10-10",null,null,null,null,null,null,null,null,null,null,"Trimmer","2021-10-10"]
[null,"T-Shirt","2021-05-11",null,null,null,null,null,null,null,null,null,null,"T-Shirt","2021-05-11"]
[null,"Jacket","2021-10-10",null,null,null,null,null,null,null,null,null,null,"Jacket","2021-10-10"]

{"sheet":"SUMPRODUCT Function Method","index":1,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,13,1,14]]}
[]
[null,"Use of SUMPRODUCT Function",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Order Date",null,null,null,null,null,null,null,null,null,null,"Product Name","Order Date"]
[null,"Watch","2021-08-11",null,"Date","Occurrence",null,null,null,null,null,null,null,"Watch","2021-08-11"]
[null,"Hat","2021-10-10",null,"2021-10-10",{"$f":"SUMPRODUCT(--(C5:C12=E6))","v":3},null,null,null,null,null,null,null,"Hat","2021-10-10"]
[null,"Shirt","2021-08-11",null,null,null,null,null,null,null,null,null,null,"Shirt","2021-08-11"]
[null,"Sunglass","2021-05-11",null,null,null,null,null,null,null,null,null,null,"Sunglass","2021-05-11"]
[null,"Shoe","2021-08-11",null,null,null,null,null,null,null,null,null,null,"Shoe","2021-08-11"]
[null,"Trimmer","2021-10-10",null,null,null,null,null,null,null,null,null,null,"Trimmer","2021-10-10"]
[null,"T-Shirt","2021-05-11",null,null,null,null,null,null,null,null,null,null,"T-Shirt","2021-05-11"]
[null,"Jacket","2021-10-10",null,null,null,null,null,null,null,null,null,null,"Jacket","2021-10-10"]

{"sheet":"Pivot Table Method","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,13,1,14]]}
[]
[null,"Use of Pivot Table",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Order Date",null,"Row Labels","Count of Order Date",null,null,null,null,null,null,null,"Product Name","Order Date"]
[null,"Watch","2021-08-11",null,"11-May",2,null,null,null,null,null,null,null,"Watch","2021-08-11"]
[null,"Hat","2021-10-10",null,"11-Aug",3,null,null,null,null,null,null,null,"Hat","2021-10-10"]
[null,"Shirt","2021-08-11",null,"10-Oct",3,null,null,null,null,null,null,null,"Shirt","2021-08-11"]
[null,"Sunglass","2021-05-11",null,"Grand Total",8,null,null,null,null,null,null,null,"Sunglass","2021-05-11"]
[null,"Shoe","2021-08-11",null,null,null,null,null,null,null,null,null,null,"Shoe","2021-08-11"]
[null,"Trimmer","2021-10-10",null,null,null,null,null,null,null,null,null,null,"Trimmer","2021-10-10"]
[null,"T-Shirt","2021-05-11",null,null,null,null,null,null,null,null,null,null,"T-Shirt","2021-05-11"]
[null,"Jacket","2021-10-10",null,null,null,null,null,null,null,null,null,null,"Jacket","2021-10-10"]

{"sheet":"Sheet","index":3,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,13,1,14]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name","Order Date",null,null,null,null,null,null,null,null,null,null,"Product Name","Order Date"]
[null,"Watch","2021-08-11",null,"Date","Occurrence",null,null,null,null,null,null,null,"Watch","2021-08-11"]
[null,"Hat","2021-10-10",null,"2021-05-11",2,null,null,null,null,null,null,null,"Hat","2021-10-10"]
[null,"Shirt","2021-08-11",null,null,null,null,null,null,null,null,null,null,"Shirt","2021-08-11"]
[null,"Sunglass","2021-05-11",null,null,null,null,null,null,null,null,null,null,"Sunglass","2021-05-11"]
[null,"Shoe","2021-08-11",null,null,null,null,null,null,null,null,null,null,"Shoe","2021-08-11"]
[null,"Trimmer","2021-10-10",null,null,null,null,null,null,null,null,null,null,"Trimmer","2021-10-10"]
[null,"T-Shirt","2021-05-11",null,null,null,null,null,null,null,null,null,null,"T-Shirt","2021-05-11"]
[null,"Jacket","2021-10-10",null,null,null,null,null,null,null,null,null,null,"Jacket","2021-10-10"]