{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","COUNTIF","COUNTIFS","SUMPRODUCT","Pivot Table","CountIf in VBA","CountIfs in 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":"Dataset","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales Report of XYZ Company"]
[]
[null,"Salesman","Region","Product","Total Sales"]
[null,"Antony","New York","Car",115320]
[null,"Mark","Jacksonville","Motor Bike",87980]
[null,"Joe","kansas","Car",105430]
[null,"Harold","Jacksonville","Car",102500]
[null,"Root","Austin","Motor Bike",68450]
[null,"Renold","Jacksonville","Car",135610]
[null,"Jim","New York","Motor Bike",75430]
[null,"Sofia","Austin","Car",98650]

{"sheet":"COUNTIF","index":1,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using COUNTIF Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Salesman","Region","Product","Total Sales",null,null,null,null,null,"Salesman","Region","Product","Total Sales"]
[null,"Antony","New York","Car",115320,null,null,null,null,null,"Antony","New York","Car",115320]
[null,"Mark","Jacksonville","Motor Bike",87980,null,null,null,null,null,"Mark","Jacksonville","Motor Bike",87980]
[null,"Joe","kansas","Car",105430,null,null,null,null,null,"Joe","kansas","Car",105430]
[null,"Harold","Jacksonville","Car",102500,null,null,null,null,null,"Harold","Jacksonville","Car",102500]
[null,"Root","Austin","Motor Bike",68450,null,null,null,null,null,"Root","Austin","Motor Bike",68450]
[null,"Renold","Jacksonville","Car",135610,null,null,null,null,null,"Renold","Jacksonville","Car",135610]
[null,"Jim","New York","Motor Bike",75430,null,null,null,null,null,"Jim","New York","Motor Bike",75430]
[null,"Sofia","Austin","Car",98650,null,null,null,null,null,"Sofia","Austin","Car",98650]
[]
[null,"Region","Jacksonville","No. of Salesman",{"$f":"COUNTIF(C5:C12,C14)","v":3},null,null,null,null,null,"Region",null,"No. of Salesman"]

{"sheet":"COUNTIFS","index":2,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Applying COUNTIFS Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Salesman","Region","Product","Total Sales",null,null,null,null,null,"Salesman","Region","Product","Total Sales"]
[null,"Antony","New York","Car",115320,null,null,null,null,null,"Antony","New York","Car",115320]
[null,"Mark","Jacksonville","Motor Bike",87980,null,null,null,null,null,"Mark","Jacksonville","Motor Bike",87980]
[null,"Joe","kansas","Car",105430,null,null,null,null,null,"Joe","kansas","Car",105430]
[null,"Harold","Jacksonville","Car",102500,null,null,null,null,null,"Harold","Jacksonville","Car",102500]
[null,"Root","Austin","Motor Bike",68450,null,null,null,null,null,"Root","Austin","Motor Bike",68450]
[null,"Renold","Jacksonville","Car",135610,null,null,null,null,null,"Renold","Jacksonville","Car",135610]
[null,"Jim","New York","Motor Bike",75430,null,null,null,null,null,"Jim","New York","Motor Bike",75430]
[null,"Sofia","Austin","Car",98650,null,null,null,null,null,"Sofia","Austin","Car",98650]
[]
[null,"Region","Product","No. of Car Seller",null,null,null,null,null,null,"Region","Product","No. of Car Seller"]
[null,"Jacksonville","Car",{"$f":"COUNTIFS(C5:C12,B15,D5:D12,C15)","v":2}]

{"sheet":"SUMPRODUCT","index":3,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Employing SUMPRODUCT Function",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Salesman","Region","Product","Total Sales",null,null,null,null,null,"Salesman","Region","Product","Total Sales"]
[null,"Antony","New York","Car",115320,null,null,null,null,null,"Antony","New York","Car",115320]
[null,"Mark","Jacksonville","Motor Bike",87980,null,null,null,null,null,"Mark","Jacksonville","Motor Bike",87980]
[null,"Joe","kansas","Car",105430,null,null,null,null,null,"Joe","kansas","Car",105430]
[null,"Harold","Jacksonville","Car",102500,null,null,null,null,null,"Harold","Jacksonville","Car",102500]
[null,"Root","Austin","Motor Bike",68450,null,null,null,null,null,"Root","Austin","Motor Bike",68450]
[null,"Renold","Jacksonville","Car",135610,null,null,null,null,null,"Renold","Jacksonville","Car",135610]
[null,"Jim","New York","Motor Bike",75430,null,null,null,null,null,"Jim","New York","Motor Bike",75430]
[null,"Sofia","Austin","Car",98650,null,null,null,null,null,"Sofia","Austin","Car",98650]
[]
[null,"Product","Car","No. of Salesman",{"$f":"SUMPRODUCT((D5:D12=C14)/COUNTIFS(B5:B12,B5:B12))","v":5},null,null,null,null,null,"Product",null,"No. of Salesman"]

{"sheet":"Pivot Table","index":4,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing Pivot Table"]
[]
[null,"Salesman","Region","Product","Total Sales"]
[null,"Antony","New York","Car",115320]
[null,"Mark","Jacksonville","Motor Bike",87980]
[null,"Joe","kansas","Car",105430]
[null,"Harold","Jacksonville","Car",102500]
[null,"Root","Austin","Motor Bike",68450]
[null,"Renold","Jacksonville","Car",135610]
[null,"Jim","New York","Motor Bike",75430]
[null,"Sofia","Austin","Car",98650]
[]
[null,"Row Labels","Count of Salesman"]
[null,"Car",5]
[null,"Motor Bike",3]
[null,"Grand Total",8]

{"sheet":"CountIf in VBA","index":5,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Incorporating CountIf Function in VBA",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Salesman","Region","Product","Total Sales",null,null,null,null,null,"Salesman","Region","Product","Total Sales"]
[null,"Antony","New York","Car",115320,null,null,null,null,null,"Antony","New York","Car",115320]
[null,"Mark","Jacksonville","Motor Bike",87980,null,null,null,null,null,"Mark","Jacksonville","Motor Bike",87980]
[null,"Joe","kansas","Car",105430,null,null,null,null,null,"Joe","kansas","Car",105430]
[null,"Harold","Jacksonville","Car",102500,null,null,null,null,null,"Harold","Jacksonville","Car",102500]
[null,"Root","Austin","Motor Bike",68450,null,null,null,null,null,"Root","Austin","Motor Bike",68450]
[null,"Renold","Jacksonville","Car",135610,null,null,null,null,null,"Renold","Jacksonville","Car",135610]
[null,"Jim","New York","Motor Bike",75430,null,null,null,null,null,"Jim","New York","Motor Bike",75430]
[null,"Sofia","Austin","Car",98650,null,null,null,null,null,"Sofia","Austin","Car",98650]

{"sheet":"CountIfs in VBA","index":6,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Engaging CountIfs Function in VBA",null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Salesman","Region","Product","Total Sales",null,null,null,null,null,"Salesman","Region","Product","Total Sales"]
[null,"Antony","New York","Car",115320,null,null,null,null,null,"Antony","New York","Car",115320]
[null,"Mark","Jacksonville","Motor Bike",87980,null,null,null,null,null,"Mark","Jacksonville","Motor Bike",87980]
[null,"Joe","kansas","Car",105430,null,null,null,null,null,"Joe","kansas","Car",105430]
[null,"Harold","Jacksonville","Car",102500,null,null,null,null,null,"Harold","Jacksonville","Car",102500]
[null,"Root","Austin","Motor Bike",68450,null,null,null,null,null,"Root","Austin","Motor Bike",68450]
[null,"Renold","Jacksonville","Car",135610,null,null,null,null,null,"Renold","Jacksonville","Car",135610]
[null,"Jim","New York","Motor Bike",75430,null,null,null,null,null,"Jim","New York","Motor Bike",75430]
[null,"Sofia","Austin","Car",98650,null,null,null,null,null,"Sofia","Austin","Car",98650]