{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","1(a) COUNTBLANK","1(a)II IF and COUNTBLANK","1(b) COUNTIF & COUNTIFS","1(c)SUM with ROWS & COLUMNS","1(d) SUMPRODUCT","2. Go To Special","3. Find &Replace","4. VBA Macro"],"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":"Dataset","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Dataset"]
[]
[null,"Product Name","Number of Sales"]
[null,"iPad",40]
[]
[null,"iPhone",34]
[null,null,26]
[null,"iPod",15]
[]
[null,"Mac",45]

{"sheet":"1(a) COUNTBLANK","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using COUNTBLANK Formula"]
[]
[null,"Product Name","Number of Sales","Blank Cells"]
[null,"iPad",40,{"$f":"COUNTBLANK(B5:C5)","v":0}]
[null,null,null,{"$f":"COUNTBLANK(B6:C6)","v":2}]
[null,"iPhone",34,{"$f":"COUNTBLANK(B7:C7)","v":0}]
[null,null,26,1]
[null,"iPod",15,0]
[null,null,null,2]
[null,"Mac",45,0]

{"sheet":"1(a)II IF and COUNTBLANK","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Nested IF and COUNTBLANK Formula"]
[]
[null,"Product Name","Number of Sales","Blank/Not Blank"]
[null,"iPad",40,{"$f":"IF(COUNTBLANK(B5:C5)=0,\"Not Blank\",\"Blank\")","v":"Not Blank"}]
[null,null,null,{"$f":"IF(COUNTBLANK(B6:C6)=0,\"Not Blank\",\"Blank\")","v":"Blank"}]
[null,"iPhone",34,"Not Blank"]
[null,null,26,"Blank"]
[null,"iPod",15,"Not Blank"]
[null,null,null,"Blank"]
[null,"Mac",45,"Not Blank"]

{"sheet":"1(b) COUNTIF & COUNTIFS","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using COUNTIF or COUNTIFS Formula"]
[]
[null,"Product Name","Number of Sales","Blank Cells","Blank Cells"]
[null,"iPad",40,{"$f":"COUNTIF(B5:C5,\"\")","v":0},{"$f":"COUNTIFS(B5:C5,\"\")","v":0}]
[null,null,null,{"$f":"COUNTIF(B6:C6,\"\")","v":2},{"$f":"COUNTIFS(B6:C6,\"\")","v":2}]
[null,"iPhone",34,0,0]
[null,null,26,1,1]
[null,"iPod",15,0,0]
[null,null,null,2,2]
[null,"Mac",45,0,0]

{"sheet":"1(c)SUM with ROWS & COLUMNS","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using SUM Nested with ROWS & COLUMNS "]
[]
[null,"Product Name","Number of Sales"]
[null,"iPad",40]
[]
[null,"iPhone",34]
[null,null,26]
[null,"iPod",15]
[]
[null,"Mac",45]
[null,"Blank Rows",{"$f":"SUM(--(MMULT(--(B5:C11<>\"\"), ROW(INDIRECT(\"B1:B\"&COLUMNS(B5:C11))))=0))","v":2}]

{"sheet":"1(d) SUMPRODUCT","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using SUMPRODUCT Formula"]
[]
[null,"Product Name","Number of Sales"]
[null,"iPad",40]
[]
[null,"iPhone",34]
[null,null,26]
[null,"iPod",15]
[]
[null,"Mac",45]
[null,"Count",{"$f":"SUMPRODUCT(--(B5:C11=\"\"))","v":5}]

{"sheet":"2. Go To Special","index":6,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Go To Special"]
[]
[null,"Product Name","Number of Sales"]
[null,"iPad",40]
[]
[null,"iPhone",34]
[null,null,26]
[null,"iPod",15]
[]
[null,"Mac",45]

{"sheet":"3. Find &Replace","index":7,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Find & Replace"]
[]
[null,"Product Name","Number of Sales"]
[null,"iPad",40]
[]
[null,"iPhone",34]
[null,null,26]
[null,"iPod",15]
[]
[null,"Mac",45]

{"sheet":"4. VBA Macro","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA Macro"]
[]
[null,"Product Name","Number of Sales"]
[null,"iPad",40]
[]
[null,"iPhone",34]
[null,null,26]
[null,"iPod",15]
[]
[null,"Mac",45]