{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["COUNTA","COUNTIF","ISTEXT","SUM","SUMPRODUCT","SIGN","Excluding Space","Filter","LSI 1","LSI 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"COUNTA","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using COUNTA Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Products","Sales Quantity (units)",null,null,null,null,null,"Products","Sales Quantity (units)"]
[null,"Apple",450,null,null,null,null,null,"Apple",450]
[null,"Banana",500,null,null,null,null,null,"Banana",500]
[null,"Lemon",370,null,null,null,null,null,"Lemon",370]
[null,"Orange",280,null,null,null,null,null,"Orange",280]
[null,"Cherry",360,null,null,null,null,null,"Cherry",360]
[null,"Number of Cells With Text",{"$f":"COUNTA(B5:C9)-COUNT(B5:C9)","v":5},null,null,null,null,null,"Number of Cells With Text",{"$f":"COUNTA(I5:J9)-COUNT(I5:J9)","v":5}]

{"sheet":"COUNTIF","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using COUNTIF Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Products","Sales Quantity (units)",null,null,null,null,null,"Products","Sales Quantity (units)"]
[null,"Apple",450,null,null,null,null,null,"Apple",450]
[null,"Banana",500,null,null,null,null,null,"Banana",500]
[null,"Lemon",370,null,null,null,null,null,"Lemon",370]
[null,"Orange",280,null,null,null,null,null,"Orange",280]
[null,"Cherry",360,null,null,null,null,null,"Cherry",360]
[null,"Number of Cells With Text",{"$f":"COUNTIF(B5:C9,\"*\")","v":5},null,null,null,null,null,"Number of Cells With Text",{"$f":"COUNTIF(I5:J9,\"*\")","v":5}]

{"sheet":"ISTEXT","index":2,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using ISTEXT Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Products","Sales Quantity (units)",null,null,null,null,null,"Products","Sales Quantity (units)"]
[null,"Apple",450,null,null,null,null,null,"Apple",450]
[null,"Banana",500,null,null,null,null,null,"Banana",500]
[null,"Lemon",370,null,null,null,null,null,"Lemon",370]
[null,"Orange",280,null,null,null,null,null,"Orange",280]
[null,"Cherry",360,null,null,null,null,null,"Cherry",360]
[null,"Number of Cells With Text",{"$f":"COUNT(IF(ISTEXT(B5:C9),1))","v":5},null,null,null,null,null,"Number of Cells With Text",{"$f":"COUNT(IF(ISTEXT(I5:J9),1))","v":5}]

{"sheet":"SUM","index":3,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using SUM Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Products","Sales Quantity (units)",null,null,null,null,null,"Products","Sales Quantity (units)"]
[null,"Apple",450,null,null,null,null,null,"Apple",450]
[null,"Banana",500,null,null,null,null,null,"Banana",500]
[null,"Lemon",370,null,null,null,null,null,"Lemon",370]
[null,"Orange",280,null,null,null,null,null,"Orange",280]
[null,"Cherry",360,null,null,null,null,null,"Cherry",360]
[null,"Number of Cells With Text",{"$f":"SUM(IF(ISTEXT(B5:C9),1))","v":5},null,null,null,null,null,"Number of Cells With Text",{"$f":"SUM(IF(ISTEXT(I5:J9),1))","v":5}]

{"sheet":"SUMPRODUCT","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using SUMPRODUCT Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Products","Sales Quantity (units)",null,null,null,null,null,"Products","Sales Quantity (units)"]
[null,"Apple",450,null,null,null,null,null,"Apple",450]
[null,"Banana",500,null,null,null,null,null,"Banana",500]
[null,"Lemon",370,null,null,null,null,null,"Lemon",370]
[null,"Orange",280,null,null,null,null,null,"Orange",280]
[null,"Cherry",360,null,null,null,null,null,"Cherry",360]
[null,"Number of Cells With Text",{"$f":"SUMPRODUCT(IF(ISTEXT(B5:C9),1))","v":5},null,null,null,null,null,"Number of Cells With Text",{"$f":"SUMPRODUCT(IF(ISTEXT(I5:J9),1))","v":5}]

{"sheet":"SIGN","index":5,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using SIGN Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Products","Sales Quantity (units)",null,null,null,null,null,"Products","Sales Quantity (units)"]
[null,"Apple",450,null,null,null,null,null,"Apple",450]
[null,"Banana",500,null,null,null,null,null,"Banana",500]
[null,"Lemon",370,null,null,null,null,null,"Lemon",370]
[null,"Orange",280,null,null,null,null,null,"Orange",280]
[null,"Cherry",360,null,null,null,null,null,"Cherry",360]
[null,"Number of Cells With Text",{"$f":"SUMPRODUCT(SIGN(ISTEXT(B5:C9)))","v":5},null,null,null,null,null,"Number of Cells With Text",{"$f":"SUMPRODUCT(SIGN(ISTEXT(I5:J9)))","v":5}]

{"sheet":"Excluding Space","index":6,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Excluding Space",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Products","Sales Quantity (units)",null,null,null,null,null,"Products","Sales Quantity (units)"]
[null,"Apple",450,null,null,null,null,null,"Apple",450]
[null,"Banana",500,null,null,null,null,null,"Banana",500]
[null,"Lemon",370,null,null,null,null,null,"Lemon",370]
[null," ",280,null,null,null,null,null," ",280]
[null,"Cherry",360,null,null,null,null,null,"Cherry",360]
[null,"Number of Cells With Text",{"$f":"COUNTIF(B5:C9,\"><\")","v":4},null,null,null,null,null,"Number of Cells With Text",{"$f":"COUNTIF(I5:J9,\"><\")","v":4}]

{"sheet":"Filter","index":7,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Counting After Filtering",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Products","Sales Quantity (units)",null,null,null,null,"Products","Sales Quantity (units)"]
[null,"Apple",450,null,null,null,null,"Apple",450]
[null,"Banana",500,null,null,null,null,"Banana",500]
[null,"Lemon",370,null,null,null,null,"Lemon",370]
[null,"Orange",280,null,null,null,null,"Orange",280]
[null,"Avocado",600,null,null,null,null,"Cherry",360]
[null,"Cherry",360,null,null,null,null,"Number of Cells With Text",5]
[null,"Number of Cells With Text",{"$f":"SUMPRODUCT(SUBTOTAL(103, INDIRECT(\"B\"&ROW(B5:C10)))*(ISTEXT(B5:C10)))","v":5}]

{"sheet":"LSI 1","index":8,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Counting Cells in Excel",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Products","Sales Quantity (units)",null,null,null,null,null,"Products","Sales Quantity (units)"]
[null,"Apple",450,null,null,null,null,null,"Apple",450]
[null,"Banana",500,null,null,null,null,null,"Banana",500]
[null,"Lemon",370,null,null,null,null,null,"Lemon",370]
[null,"Orange",280,null,null,null,null,null,"Orange",280]
[null,"Cherry",360,null,null,null,null,null,"Cherry",360]
[null,"Number of Cells With Text",10,null,null,null,null,null,"Number of Cells With Text"]

{"sheet":"LSI 2","index":9,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Counting Cells with Numbers",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Products","Sales Quantity (units)",null,null,null,null,null,"Products","Sales Quantity (units)"]
[null,"Apple",450,null,null,null,null,null,"Apple",450]
[null,"Banana",500,null,null,null,null,null,"Banana",500]
[null,"Lemon",370,null,null,null,null,null,"Lemon",370]
[null,"Orange",280,null,null,null,null,null,"Orange",280]
[null,"Cherry",360,null,null,null,null,null,"Cherry",360]
[null,"Number of Cells With Numbers",{"$f":"COUNT(B5:C9)","v":5},null,null,null,null,null,"Number of Cells With Numbers",{"$f":"COUNT(I5:J9)","v":5}]