{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","COUNTA Function","SUBTOTAL Function","AGGREGATE Function","VBA","Specific Criteria","SUM Function"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset Overview"]
[]
[null,"Books","Genre","Author","Price"]
[null,"The Silent Patient","Thriller","Alex Michaelides",13.95]
[null,"Sharp Objects","Mystery","Gillian Flynn",18.989999999999998]
[null,"My Lovely Wife","Psychological Thriller","Samantha Downing",8.99]
[null,"The Outsider","Horror - Mystery","Stephen King",11.99]
[null,"Pet Sematary","Horror","Stephen King",13.49]
[null,"Murder on the Orient Express","Detective","Agatha Christie",6.99]
[null,"Deadly Cross","Detective","James Patterson",14.15]
[null,"3:00 A. M","Thriller","Nick Pirog",8]
[null,"Fair Warning","Crime Fiction","Michael Connelly",14.5]
[null,"Left You Dead","Suspense","Peter James",26.95]

{"sheet":"COUNTA Function","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[15,2,15,3]]}
[]
[null,"Using COUNTA Function"]
[]
[null,"Books","Genre","Author","Price"]
[null,"The Silent Patient","Thriller","Alex Michaelides",13.95]
[null,"Sharp Objects","Mystery","Gillian Flynn",18.989999999999998]
[null,"My Lovely Wife","Psychological Thriller","Samantha Downing",8.99]
[null,"The Outsider","Horror - Mystery","Stephen King",11.99]
[null,"Pet Sematary","Horror","Stephen King",13.49]
[null,"Murder on the Orient Express","Detective","Agatha Christie",6.99]
[null,"Deadly Cross","Detective","James Patterson",14.15]
[null,"3:00 A. M","Thriller","Nick Pirog",8]
[null,"Fair Warning","Crime Fiction","Michael Connelly",14.5]
[null,"Left You Dead","Suspense","Peter James",26.95]
[]
[null,null,"Count of Visible Rows",null,{"$f":"COUNTA(E5:E14)","v":10}]

{"sheet":"SUBTOTAL Function","index":2,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using SUBTOTAL Function",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Books","Genre","Author","Price",null,null,null,null,null,null,"Books","Genre","Author","Price"]
[null,"The Silent Patient","Thriller","Alex Michaelides",13.95,null,null,null,null,null,null,"The Silent Patient","Thriller","Alex Michaelides",13.95]
[null,"Sharp Objects","Mystery","Gillian Flynn",18.989999999999998,null,null,null,null,null,null,"Sharp Objects","Mystery","Gillian Flynn",18.989999999999998]
[null,"My Lovely Wife","Psychological Thriller","Samantha Downing",8.99,null,null,null,null,null,null,"My Lovely Wife","Psychological Thriller","Samantha Downing",8.99]
[null,"The Outsider","Horror - Mystery","Stephen King",11.99,null,null,null,null,null,null,"The Outsider","Horror - Mystery","Stephen King",11.99]
[null,"Pet Sematary","Horror","Stephen King",13.49,null,null,null,null,null,null,"Pet Sematary","Horror","Stephen King",13.49]
[null,"Murder on the Orient Express","Detective","Agatha Christie",6.99,null,null,null,null,null,null,"Murder on the Orient Express","Detective","Agatha Christie",6.99]
[null,"Deadly Cross","Detective","James Patterson",14.15,null,null,null,null,null,null,"Deadly Cross","Detective","James Patterson",14.15]
[null,"3:00 A. M","Thriller","Nick Pirog",8,null,null,null,null,null,null,"3:00 A. M","Thriller","Nick Pirog",8]
[null,"Fair Warning","Crime Fiction","Michael Connelly",14.5,null,null,null,null,null,null,"Fair Warning","Crime Fiction","Michael Connelly",14.5]
[null,"Left You Dead","Suspense","Peter James",26.95,null,null,null,null,null,null,"Left You Dead","Suspense","Peter James",26.95]
[]
[null,"Scenario","Count of Visible Rows","Formula",null,null,null,null,null,null,null,"Count of Visible Rows"]
[null,"In Case of Text (COUNTA Function)",{"$f":"SUBTOTAL(3,B5:B14)","v":5},{"$f":"_xlfn.FORMULATEXT(C17)","v":"=SUBTOTAL(3,B5:B14)"}]
[null,"In Case of Numbers (COUNT Function)",{"$f":"SUBTOTAL(2,E5:E14)","v":5},{"$f":"_xlfn.FORMULATEXT(C18)","v":"=SUBTOTAL(2,E5:E14)"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"AGGREGATE Function","index":3,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying AGGREGATE Function"]
[]
[null,"Books","Genre","Author"]
[null,"The Silent Patient","Thriller","Alex Michaelides"]
[null,"Sharp Objects","Mystery","Gillian Flynn"]
[null,"My Lovely Wife","Psychological Thriller","Samantha Downing"]
[null,"The Outsider","Horror - Mystery","Stephen King"]
[null,"Pet Sematary","Horror","Stephen King"]
[null,"Murder on the Orient Express","Detective","Agatha Christie"]
[null,"Deadly Cross","Detective","James Patterson"]
[null,"3:00 A. M","Thriller","Nick Pirog"]
[null,"Fair Warning","Crime Fiction","Michael Connelly"]
[null,"Left You Dead","Suspense","Peter James"]
[]
[null,"Options","Count of Visible Rows","Formula"]
[null,"1-Ignore hidden rows, nested...functions",{"$f":"_xlfn.AGGREGATE(3,1,B5:B14)","v":6},{"$f":"_xlfn.FORMULATEXT(C17)","v":"=AGGREGATE(3,1,B5:B14)"}]
[null,"3-Ignore hidden rows, error values",{"$f":"_xlfn.AGGREGATE(3,3,B5:B14)","v":6},{"$f":"_xlfn.FORMULATEXT(C18)","v":"=AGGREGATE(3,3,B5:B14)"}]
[null,"5-Ignore hidden rows ",{"$f":"_xlfn.AGGREGATE(3,5,B5:B14)","v":6},{"$f":"_xlfn.FORMULATEXT(C19)","v":"=AGGREGATE(3,5,B5:B14)"}]
[null,"7-Ignore hidden rows and error values ",{"$f":"_xlfn.AGGREGATE(3,7,B5:B14)","v":6},{"$f":"_xlfn.FORMULATEXT(C20)","v":"=AGGREGATE(3,7,B5:B14)"}]

{"sheet":"VBA","index":4,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Macros"]
[]
[null,"Books","Genre","Author"]
[null,"The Silent Patient","Thriller","Alex Michaelides"]
[null,"Sharp Objects","Mystery","Gillian Flynn"]
[null,"My Lovely Wife","Psychological Thriller","Samantha Downing"]
[null,"The Outsider","Horror - Mystery","Stephen King"]
[null,"Pet Sematary","Horror","Stephen King"]
[null,"Murder on the Orient Express","Detective","Agatha Christie"]
[null,"Deadly Cross","Detective","James Patterson"]
[null,"3:00 A. M","Thriller","Nick Pirog"]
[null,"Fair Warning","Crime Fiction","Michael Connelly"]
[null,"Left You Dead","Suspense","Peter James"]
[]
[null,"Count of Visible Rows",{"$f":"COUNTVISIBLE(C5:C14)","v":{"$error":"#NAME?"}}]

{"sheet":"Specific Criteria","index":5,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employing SUMPRODUCT Function for Specific Criteria"]
[]
[null,"Books","Genre","Author"]
[null,"The Silent Patient","Thriller","Alex Michaelides"]
[null,"Sharp Objects","Mystery","Gillian Flynn"]
[null,"My Lovely Wife","Psychological Thriller","Samantha Downing"]
[null,"The Outsider","Horror - Mystery","Stephen King"]
[null,"Pet Sematary","Horror","Stephen King"]
[null,"Murder on the Orient Express","Detective","Agatha Christie"]
[null,"Deadly Cross","Detective","James Patterson"]
[null,"3:00 A. M","Thriller","Nick Pirog"]
[null,"Fair Warning","Crime Fiction","Michael Connelly"]
[null,"Left You Dead","Suspense","Peter James"]
[]
[null,"Search Key","Detective"]
[]
[null,"Criteria","Count of Visible Rows"]
[null,"SUMPRODUCT with OFFSET function",{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET(C5:C14,ROW(C5:C14)-MIN(ROW(C5:C14)),,1)), --(C5:C14=C16))","v":1}]
[null,"SUMPRODUCT with INDIRECT function",{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"B\"&ROW(C5:C14))),--(C5:C14=C16))","v":1}]

{"sheet":"SUM Function","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,4]]}
[]
[null,"Count of Visible Rows Using SUM Function"]
[]
[null,"Books","Genre","Author","Price","Number of Visible Rows"]
[null,"The Silent Patient","Thriller","Alex Michaelides",13.95,{"$f":"_xlfn.AGGREGATE(3,5,B5)","v":1}]
[null,"Sharp Objects","Mystery","Gillian Flynn",18.989999999999998,{"$f":"_xlfn.AGGREGATE(3,5,B6)","v":0}]
[null,"My Lovely Wife","Psychological Thriller","Samantha Downing",8.99,0]
[null,"The Outsider","Horror - Mystery","Stephen King",11.99,0]
[null,"Pet Sematary","Horror","Stephen King",13.49,{"$f":"_xlfn.AGGREGATE(3,5,B9)","v":1}]
[null,"Murder on the Orient Express","Detective","Agatha Christie",6.99,0]
[null,"Deadly Cross","Detective","James Patterson",14.15,0]
[null,"3:00 A. M","Thriller","Nick Pirog",8,1]
[null,"Fair Warning","Crime Fiction","Michael Connelly",14.5,1]
[null,"Left You Dead","Suspense","Peter James",26.95,0]
[]
[null,"Count of Visible Rows",null,null,null,{"$f":"SUM(F5:F13)","v":4}]