{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Using the COUNTIF Function"," Applying COUNTIFS Function","Using  Pivot Table","Pivot Table","Utilising SUMPRODUCT Function","COUNTIF VBA","COUNTIFS VBA","Practice"],"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":"Using the COUNTIF Function","index":0,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,7]]}
[]
[]
[null,"Using COUNTIF Function"]
[]
[null,"Areas","Month","Products","Total Sales",null,"Product","MacBook"]
[null,"New York","January","iPhone",10000,null,"No.of Area",{"$f":"COUNTIF(D6:D17,H5)","v":3}]
[null,"Michigan","February","iPhone",25900]
[null,"Detroit ","March","Apple Watch",1200]
[null,"Carolina","April","iPhone ",1397]
[null,"California","May","iPhone",780]
[null,"Oklahoma","June","MacBook",120000]
[null,"Texas","July","Apple Watch",4570]
[null,"Alaska","August","MacBook",78000]
[null,"Florida","September","Apple Watch",800]
[null,"Virginia","October","iPad",9400]
[null,"Arizona","November","MacBook",2200]
[null,"Nevada","December","Apple Watch",1250]

{"sheet":" Applying COUNTIFS Function","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,7]]}
[]
[]
[null,"Applying COUNTIFS Function"]
[]
[null,"Area","Month","Products","Total Sales",null,"Product","Apple Watch"]
[null,"New York","January","iPhone",10000,null,"Month","January"]
[null,"Michigan","January","iPhone",25900]
[null,"Detroit ","January","Apple Watch",1200,null,"No. of Areas",{"$f":"COUNTIFS(D6:D17,H5,C6:C17,H6)","v":1}]
[null,"Carolina","January","iPhone ",1397]
[null,"California","January","iPhone",780]
[null,"Oklahoma","April","MacBook",120000]
[null,"Texas","April","Apple Watch",4570]
[null,"Alaska","April","MacBook",78000]
[null,"Florida","December","Apple Watch",800]
[null,"Virginia","December","iPhone",9400]
[null,"Arizona","December","MacBook",2200]
[null,"Nevada","December","Apple Watch",1250]

{"sheet":"Using  Pivot Table","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Using Pivot Table"]
[]
[null,"Areas","Month","Products","Total Sales"]
[null,"New York","January","iPhone",10000]
[null,"Michigan","January","iPhone",25900]
[null,"Detroit ","January","Apple Watch",1200]
[null,"Carolina","January","iPhone ",1397]
[null,"California","January","iPhone",780]
[null,"Oklahoma","April","MacBook",120000]
[null,"Texas","April","Apple Watch",4570]
[null,"Alaska","April","MacBook",78000]
[null,"Florida","December","Apple Watch",800]
[null,"Virginia","December","iPhone",9400]
[null,"Arizona","December","MacBook",2200]
[null,"Nevada","December","Apple Watch",1250]

{"sheet":"Pivot Table","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Using Pivot Table"]
[]
[null,"Areas","Count of Products"]
[null,"January",5]
[null,"April",3]
[null,"December",4]
[null,"Grand Total",12]

{"sheet":"Utilising SUMPRODUCT Function","index":4,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,7]]}
[]
[]
[null,"Utilsing SUMPRODUCT Function"]
[]
[null,"Area","Month","Products","Total Sales",null,"Product","Apple Watch"]
[null,"New York","January","iPhone",10000,null,"No.of Areas",{"$f":"SUMPRODUCT((D6:D17=H5)/COUNTIF(B6:B17,B6:B17))","v":4}]
[null,"Michigan","January","iPhone",25900]
[null,"Detroit ","January","Apple Watch",1200]
[null,"Carolina","January","iPhone ",1397]
[null,"California","January","iPhone",780]
[null,"Oklahoma","April","MacBook",120000]
[null,"Texas","April","Apple Watch",4570]
[null,"Alaska","April","MacBook",78000]
[null,"Florida","December","Apple Watch",800]
[null,"Virginia","December","iPhone",9400]
[null,"Arizona","December","MacBook",2200,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((D6:D17=H5)/COUNTIF(B6:B17,B6:B17))","v":4}]
[null,"Nevada","December","Apple Watch",1250]

{"sheet":"COUNTIF VBA","index":5,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Employing COUNTIF Function in VBA"]
[]
[null,"Area","Month","Products","Total Sales"]
[null,"New York","January","iPad ",10000]
[null,"Michigan","January","iPhone",25900]
[null,"Detroit ","January","Apple Watch",1200]
[null,"Carolina","January","iPad ",1397]
[null,"California","January","iPad ",780]
[null,"Oklahoma","April","MacBook",120000]
[null,"Texas","April","iPhone",4570]
[null,"Alaska","April","MacBook",78000]
[null,"Florida","December","Apple Watch",800]
[null,"Virginia","December","iPhone",9400]
[null,"Arizona","December","MacBook",2200]
[null,"Nevada","December","Apple Watch",1250]

{"sheet":"COUNTIFS VBA","index":6,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Applying COUNTIFS Function in VBA"]
[]
[null,"Area","Month","Products","Total Sales"]
[null,"New York","January","iPad",10000]
[null,"Michigan","January","iPhone",25900]
[null,"Detroit ","January","Apple Watch",1200]
[null,"Carolina","January","iPad",1397]
[null,"California","January","iPad",780]
[null,"Michigan","April","MacBook",120000]
[null,"Texas","April","iPhone",4570]
[null,"New York","April","MacBook",78000]
[null,"Florida","December","Apple Watch",800]
[null,"California","December","iPhone",9400]
[null,"Detroit ","December","MacBook",2200]
[null,"Texas","December","Apple Watch",1250]

{"sheet":"Practice","index":7,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Count one Column if Another Meets Criteria"]
[]
[null,"Area","Month","Products","Total Sales"]
[null,"New York","January","iPhone",10000]
[null,"Michigan","January","iPhone",25900]
[null,"Detroit ","January","Apple Watch",1200]
[null,"Carolina","January","iPhone",1397]
[null,"California","January","iPhone",780]
[null,"Oklahoma","April","MacBook",120000]
[null,"Texas","April","iPhone",4570]
[null,"Alaska","April","MacBook",78000]
[null,"Florida","December","Apple Watch",800]
[null,"Virginia","December","iPhone",9400]
[null,"Arizona","December","MacBook",2200]
[null,"Nevada","December","Apple Watch",1250]