{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Counting colu if meets criteria","Countif","Countifs","Sumproduct & Countifs","Pivot table","VBA"],"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":"Counting colu if meets criteria","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Counting One Column if Another Column Meets Crtiteria"]
[]
[null,"Salesman","Product","Selling Date"]
[null,"Tobby","Desktop","2022-12-01"]
[null,"Dwight","Laptop","2022-12-01"]
[null,"Michael","MacBook","2022-12-05"]
[null,"Angela","Television","2022-12-04"]
[null,"Oscar","Laptop","2022-12-05"]
[null,"Jim","Laptop","2022-12-02"]
[null,"Pam","MacBook","2022-12-05"]
[]
[null,"Product","Laptop"]
[null,"No. of Sold Product"]

{"sheet":"Countif","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Counting One Column if Another Column Meets Crtiteria",null,null,null,null,"Try Yourself"]
[]
[null,"Salesman","Product","Selling Date",null,null,"Salesman","Product","Selling Date"]
[null,"Tobby","Desktop","2022-12-01",null,null,"Tobby","Desktop","2022-12-01"]
[null,"Dwight","Laptop","2022-12-01",null,null,"Dwight","Laptop","2022-12-01"]
[null,"Michael","MacBook","2022-12-05",null,null,"Michael","MacBook","2022-12-05"]
[null,"Angela","Television","2022-12-04",null,null,"Angela","Television","2022-12-04"]
[null,"Oscar","Laptop","2022-12-05",null,null,"Oscar","Laptop","2022-12-05"]
[null,"Jim","Laptop","2022-12-02",null,null,"Jim","Laptop","2022-12-02"]
[null,"Pam","MacBook","2022-12-05",null,null,"Pam","MacBook","2022-12-05"]
[]
[null,"Product","Laptop",null,null,null,"Product","Laptop"]
[null,"No. of Sold Product",{"$f":"COUNTIF(C6:C12,C14)","v":3},null,null,null,"No. of Sold Product"]

{"sheet":"Countifs","index":2,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Counting One Column if Another Column Meets Crtiteria",null,null,null,null,"Try Yourself"]
[]
[null,"Salesman","Product","Selling Date",null,null,"Salesman","Product","Selling Date"]
[null,"Tobby","Desktop","2022-12-01",null,null,"Tobby","Desktop","2022-12-01"]
[null,"Dwight","Laptop","2022-12-01",null,null,"Dwight","Laptop","2022-12-01"]
[null,"Michael","MacBook","2022-12-05",null,null,"Michael","MacBook","2022-12-05"]
[null,"Angela","Television","2022-12-04",null,null,"Angela","Television","2022-12-04"]
[null,"Oscar","Laptop","2022-12-05",null,null,"Oscar","Laptop","2022-12-05"]
[null,"Jim","Laptop","2022-12-02",null,null,"Jim","Laptop","2022-12-02"]
[null,"Pam","MacBook","2022-12-05",null,null,"Pam","MacBook","2022-12-05"]
[]
[null,"Product","Laptop",null,null,null,"Product","Laptop"]
[null,"Selling Date","2022-12-01",null,null,null,"Selling Date","2022-12-01"]
[null,"No. of Sold Product",{"$f":"COUNTIFS(C6:C12,C14,D6:D12,C15)","v":1},null,null,null,"No. of Sold Product"]

{"sheet":"Sumproduct & Countifs","index":3,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Counting One Column if Another Column Meets Crtiteria",null,null,null,null,"Try Yourself"]
[]
[null,"Salesperson","Product","Selling Date",null,null,"Salesperson","Product","Selling Date"]
[null,"Tobby","Desktop","2022-12-01",null,null,"Tobby","Desktop","2022-12-01"]
[null,"Dwight","Laptop","2022-12-01",null,null,"Dwight","Laptop","2022-12-01"]
[null,"Michael","MacBook","2022-12-05",null,null,"Michael","MacBook","2022-12-05"]
[null,"Angela","Television","2022-12-04",null,null,"Angela","Television","2022-12-04"]
[null,"Oscar","Laptop","2022-12-05",null,null,"Oscar","Laptop","2022-12-05"]
[null,"Jim","Laptop","2022-12-02",null,null,"Jim","Laptop","2022-12-02"]
[null,"Pam","MacBook","2022-12-05",null,null,"Pam","MacBook","2022-12-05"]
[]
[null,"Product","Laptop",null,null,null,"Product","Laptop"]
[null,"No. of Salesperson",{"$f":"SUMPRODUCT((C6:C12=C14)/COUNTIFS(B6:B12,B6:B12))","v":3},null,null,null,"No. of Salesperson"]

{"sheet":"Pivot table","index":4,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Counting One Column if Another Column Meets Crtiteria",null,null,null,null,"Try Yourself"]
[]
[null,"Salesman","Product","Selling Date",null,null,"Salesman","Product","Selling Date"]
[null,"Tobby","Desktop","2022-12-01",null,null,"Tobby","Desktop","2022-12-01"]
[null,"Dwight","Laptop","2022-12-01",null,null,"Dwight","Laptop","2022-12-01"]
[null,"Michael","MacBook","2022-12-05",null,null,"Michael","MacBook","2022-12-05"]
[null,"Angela","Television","2022-12-04",null,null,"Angela","Television","2022-12-04"]
[null,"Oscar","Laptop","2022-12-05",null,null,"Oscar","Laptop","2022-12-05"]
[null,"Jim","Laptop","2022-12-02",null,null,"Jim","Laptop","2022-12-02"]
[null,"Pam","MacBook","2022-12-05",null,null,"Pam","MacBook","2022-12-05"]
[]
[null,"Row Labels","Count of Product"]
[null,"Desktop",1]
[null,"Laptop",3]
[null,"MacBook",2]
[null,"Television",1]
[null,"Grand Total",7]

{"sheet":"VBA","index":5,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Counting One Column if Another Column Meets Crtiteria",null,null,null,null,"Try Yourself"]
[]
[null,"Salesman","Product","Selling Date",null,null,"Salesman","Product","Selling Date"]
[null,"Tobby","Desktop","2022-12-01",null,null,"Tobby","Desktop","2022-12-01"]
[null,"Dwight","Laptop","2022-12-01",null,null,"Dwight","Laptop","2022-12-01"]
[null,"Michael","MacBook","2022-12-05",null,null,"Michael","MacBook","2022-12-05"]
[null,"Angela","Television","2022-12-04",null,null,"Angela","Television","2022-12-04"]
[null,"Oscar","Laptop","2022-12-05",null,null,"Oscar","Laptop","2022-12-05"]
[null,"Jim","Laptop","2022-12-02",null,null,"Jim","Laptop","2022-12-02"]
[null,"Pam","MacBook","2022-12-05",null,null,"Pam","MacBook","2022-12-05"]
[]
[null,"Product","Laptop",null,null,null,"Product","Laptop"]
[null,"Selling Date","2022-12-01",null,null,null,"Selling Date","2022-12-01"]
[null,"No. of Sold Product",1,null,null,null,"No. of Sold Product"]