{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Partially Matched","Exact Matched","Data Validation","SUMPRODUCT","VBA","Filter","All Types Text","Substrings"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Fruit List","Amount (KG)"]
[null,"Apple",5]
[null,"Pineapple"]
[null,"Guava",2]
[null,"Papaya",5]
[null,"Lychee",2]
[null,"Orange",3]
[null,"Lychee"]
[null,"Apple",6]
[null,"Pineapple",4]
[null,"Jackfruit"]
[null,"Pineapple",4]

{"sheet":"Partially Matched","index":1,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Counting Partially Matched Text"]
[]
[null,"Fruit List","Amount (KG)"]
[null,"Apple",5]
[null,"Pineapple"]
[null,"Guava",2]
[null,"Papaya",5]
[null,"Lychee",2]
[null,"Orange",3]
[null,"Lychee"]
[null,"Apple",6]
[null,"Pineapple",4]
[null,"Jackfruit"]
[null,"Pineapple",4]
[]
[null,"Counted Cells"]

{"sheet":"Exact Matched","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Counting Exact Matching Text"]
[]
[null,"Fruit List","Amount (KG)"]
[null,"Apple",5]
[null,"Pineapple"]
[null,"Guava",2]
[null,"Papaya",5]
[null,"Lychee",2]
[null,"Orange",3]
[null,"Lychee"]
[null,"Apple",6]
[null,"Pineapple",4]
[null,"Jackfruit"]
[null,"Pineapple",4]
[]
[null,"Counted Cells"]

{"sheet":"Data Validation","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Counting Cells with Data Validation"]
[]
[null,"Fruit List","Amount (KG)"]
[null,"Apple",5]
[null,"Pineapple"]
[null,"Guava",2]
[null,"Papaya",5]
[null,"Lychee",2,null,"Text","Apple"]
[null,"Orange",3,null,"Counted Cells"]
[null,"Lychee"]
[null,"Apple",6]
[null,"Pineapple",4]
[null,"Jackfruit"]
[null,"Pineapple",4]

{"sheet":"SUMPRODUCT","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying SUMPRODUCT Function"]
[]
[null,"Fruit List","Amount (KG)"]
[null,"Apple",5]
[null,"Pineapple"]
[null,"Guava",2]
[null,"Papaya",5]
[null,"Lychee",2]
[null,"Orange",3]
[null,"Lychee"]
[null,"Apple",6]
[null,"Pineapple",4]
[null,"Jackfruit"]
[null,"Pineapple",4]
[]
[null,"Counted Cells"]

{"sheet":"VBA","index":5,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying Excel VBA"]
[]
[null,"Fruit List","Amount (KG)"]
[null,"Apple",5]
[null,"Pineapple"]
[null,"Guava",2]
[null,"Papaya",5]
[null,"Lychee",2]
[null,"Orange",3]
[null,"Lychee"]
[null,"Apple",6]
[null,"Pineapple",4]
[null,"Jackfruit"]
[null,"Pineapple",4]

{"sheet":"Filter","index":6,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying Filter for Counting Cells"]
[]
[null,"Fruit List","Amount (KG)"]
[null,"Apple",5]
[null,"Pineapple"]
[null,"Guava",2]
[null,"Papaya",5]
[null,"Lychee",2]
[null,"Orange",3]
[null,"Lychee"]
[null,"Apple",6]
[null,"Pineapple",4]
[null,"Jackfruit"]
[null,"Pineapple",4]
[]
[null,"Text","Apple"]
[null,"Counted Cells"]
[]
[]
[]
[null,null,{"$f":"SUMPRODUCT(--(ISNUMBER(FIND(B5,B5:B15))))","v":2}]

{"sheet":"All Types Text","index":7,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Counting All Types Text"]
[]
[null,"Fruit List","Amount (KG)"]
[null,"Apple",5]
[null,"Pineapple"]
[null,"Guava",2]
[null,"Papaya",5]
[null,"Lychee",2]
[null,"Orange",3]
[null,"Lychee"]
[null,"Apple",6]
[null,"Pineapple",4]
[null,"Jackfruit"]
[null,"Pineapple",4]
[]
[null,"Counted Cells"]
[]
[null,null,{"$f":"SUMPRODUCT(--(ISTEXT(B5:C15)))","v":11}]

{"sheet":"Substrings","index":8,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Counting with Multiple Substrings"]
[]
[null,"Product Detail"]
[null,"T-Shirt-Blue-XL"]
[null,"T-Shirt-Blue-L",null,"Dress","T-Shirt"]
[null,"Jeans-Black-M",null,"Color","Blue"]
[null,"Jeans-Black-L",null,"Quantity"]
[null,"Skirt-Yellow-M",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(B5:B12,\"*T-Shirt*\", B5:B12,\"*Blue*\")","v":2}]
[null,"Skirt-Blue-S"]
[null,"T-Shirt-White-XL"]
[null,"Shirt-Blue-L"]
[null,null,null,null,{"$f":"COUNTIFS(B5:B12,\"*\"&E6&\"*\", B5:B12,\"*\"&E7&\"*\")","v":2}]