{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","COUNTIF Function","ISTEXT and SUMPRODUCT","Specific Text","COUNTIFS Function","VBA Code","a Number","Multiple Text"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Sales Report of ABC Agro",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Year","Product","Sales",null,null,null,"Year","Product","Sales"]
[null,1,"Apple",100,null,null,null,1,"Apple",100]
[null,2,"Pine-apple",150,null,null,null,2,"Pine-apple",150]
[null,3,"Mango",120,null,null,null,3,"Mango",120]
[null,4,"Litchee",300,null,null,null,4,"Litchee",300]
[null,5,"Grape",220,null,null,null,5,"Grape",220]
[null,6,"Avocado",250,null,null,null,6,"Avocado",250]
[]
[null,null,"COUNT",null,null,null,null,null,"COUNT"]

{"sheet":"COUNTIF Function","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using COUNTIF Function"]
[]
[null,"Year","Product","Sales"]
[null,1,"Apple",100]
[null,2,"Pine-apple",150]
[null,3,"Mango",120]
[null,4,"Litchee",300]
[null,5,"Grape",220]
[null,6,"Avocado",250]
[]
[null,null,"COUNT",{"$f":"COUNTIF(C5:C10,\"*\")","v":6}]

{"sheet":"ISTEXT and SUMPRODUCT","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combination of ISTEXT and SUMPRODUCT Functions"]
[]
[null,"Year","Product","Sales"]
[null,1,"Apple",100]
[null,2,"Pine-apple",150]
[null,3,"Mango",120]
[null,4,"Litchee",300]
[null,5,"Grape",220]
[null,6,"Avocado",250]
[]
[null,null,"COUNT",{"$f":"SUMPRODUCT(--ISTEXT(C5:C10))","v":6}]

{"sheet":"Specific Text","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using COUNTIF Function "]
[]
[null,"Year","Product","Sales"]
[null,1,"Apple",100]
[null,2,"Pine-apple",150]
[null,3,"Mango",120]
[null,4,"Litchee",300]
[null,5,"Grape",220]
[null,6,"Avocado",250]
[]
[null,null,"COUNT",{"$f":"COUNTIF(C5:C10,\"*apple*\")","v":2}]

{"sheet":"COUNTIFS Function","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Utilizing COUNTIFS Function"]
[]
[null,"Year","Product","Sales"]
[null,1,"Apple",100]
[null,2,"Pine-apple",150]
[null,3,"Mango",120]
[null,4,"Litchee",300]
[null,5,"Grape",220]
[null,6,"Avocado",250]
[]
[null,null,"COUNT",{"$f":"COUNTIFS(C5:C10,\"mango\")","v":1}]

{"sheet":"VBA Code","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Application of a VBA Code"]
[]
[null,"Year","Product","Sales"]
[null,1,"Apple",100]
[null,2,"Pine-apple",150]
[null,3,"Mango",120]
[null,4,"Litchee",300]
[null,5,"Grape",220]
[null,6,"Avocado",250]
[]
[null,null,"COUNT"]

{"sheet":"a Number","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Counting If a Cell Contains a Number"]
[]
[null,"Year","Product","Sales"]
[null,1,"Apple","No Sale"]
[null,2,"Pine-apple",150]
[null,3,"Mango",120]
[null,4,"Litchee",300]
[null,5,"Grape","No Sale"]
[null,6,"Avocado",250]
[]
[null,null,"COUNT",{"$f":"COUNT(D5:D10)","v":4}]

{"sheet":"Multiple Text","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Counting If a Cell Contains a Multiple Text"]
[]
[null,"Year","Product","Sales"]
[null,1,"Apple",100]
[null,2,"Pine-apple",150]
[null,3,"Mango",120]
[null,4,"Litchee",300]
[null,5,"Grape",220]
[null,6,"Avocado",250]
[]
[null,null,"COUNT",{"$f":"COUNTIF(C5:C10,\"mango\")+COUNTIF(B5:B10,\"3\")","v":2}]