{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Example","Text","Number","Range Object","Formula","FormulaR1C1","Variable"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Example","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"WorksheetFunction with COUNTIF"]
[]
[null,"Data"]
[null,0.2]
[null,1]
[null,5]
[null,8.6999999999999993]
[null,1.5]
[null,2.9]
[]
[null,"Count"]
[null,4]

{"sheet":"Text","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COUNTIF to Count Text"]
[]
[null,"Names"]
[null,"John"]
[null,"Roman",null,"Name","John"]
[null,"Dean",null,"Count",2]
[null,"John"]
[null,"Seth"]
[null,"Roman"]

{"sheet":"Number","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COUNTIF to Calculate Number"]
[]
[null,"Numbers"]
[null,0.8]
[null,0.9,null,"Greater Than",1.1000000000000001]
[null,1,null,"Count",3]
[null,1.2]
[null,1.3]
[null,1.4]

{"sheet":"Range Object","index":3,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COUNTIF Function with a Range of Object "]
[]
[null,"Values"]
[null,0.2]
[null,0.9]
[null,5]
[null,0.7]
[null,1.5]
[null,2.9]
[]
[null,"Count & Sum"]
[null,9.4]

{"sheet":"Formula","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COUNTIF Function with Formula"]
[]
[null,"Data"]
[null,0.2]
[null,1]
[null,5]
[null,8.6999999999999993]
[null,1.5]
[null,2.9]
[]
[null,"Count"]
[null,{"$f":"COUNTIF(B5:B10, \">1\")","v":4}]

{"sheet":"FormulaR1C1","index":5,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COUNTIF Function with FormulaR1C1"]
[]
[null,"Data"]
[null,0.2]
[null,1]
[null,5]
[null,8.6999999999999993]
[null,1.5]
[null,2.9]
[]
[null,"Count"]
[null,{"$f":"COUNTIF(B5:B12,\">2\")","v":3}]

{"sheet":"Variable","index":6,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Assign the COUNTIF Result to Variable "]
[]
[null,"Data"]
[null,0.2]
[null,1]
[null,5]
[null,8.6999999999999993]
[null,1.5]
[null,2.9]