{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["COUNTIF","SUMPRODUCT, EXACT","SUMPRODUCT, ISNUMBER, FIND","COUNTIFS","VBA"],"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":"COUNTIF","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of COUNTIF Function"]
[]
[null,"Book Name","Published year","Author","Genre"]
[null,"Great Expectations",1860,"Charles Dickens","Biographical Novel"]
[null,"Jane Eyre",1847,"Charlotte Bronte","Biographical Novel"]
[null,"The Return of the Native",1878,"Thomas Hardy","Social Novel"]
[null,"Shirley",1849,"Charlotte Bronte","Biographical Novel"]
[null,"To The Lighthouse",1927,"Virginia Woolf","Modernist Novel"]
[null,"The Mayor of Casterbridge",1886,"Thomas Hardy","Social Novel"]
[null,"The Catcher in the Rye",1945,"J. D. Salinger","Fiction Novel"]
[null,"Wuthering Heights",1847,"Emily Bronte","Biographical Novel"]
[null,"A Tale of Two Cities",1859,"Charles Dickens","Historical Novel"]
[null,"The Scarlet Letter",1860,"Nathaniel Hawthorne","Romantic Novel"]
[]
[null,"No. of Biographical Novels",{"$f":"COUNTIF(E5:E14,\"Biographical Novel\")","v":4}]

{"sheet":"SUMPRODUCT, EXACT","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combination of SUMPRODUCT and EXACT Functions"]
[]
[null,"Book Name","Published year","Author","Genre"]
[null,"Great Expectations",1860,"Charles Dickens","Biographical Novel"]
[null,"Jane Eyre",1847,"Charlotte Bronte","Biographical Novel"]
[null,"The Return of the Native",1878,"Thomas Hardy","Social Novel"]
[null,"Shirley",1849,"Charlotte Bronte","Biographical Novel"]
[null,"To The Lighthouse",1927,"Virginia Woolf","Modernist Novel"]
[null,"The Mayor of Casterbridge",1886,"Thomas Hardy","Social Novel"]
[null,"The Catcher in the Rye",1945,"J. D. Salinger","Fiction Novel"]
[null,"Wuthering Heights",1847,"Emily Bronte","Biographical Novel"]
[null,"A Tale of Two Cities",1859,"Charles Dickens","Historical Novel"]
[null,"The Scarlet Letter",1860,"Nathaniel Hawthorne","Romantic Novel"]
[]
[null,"Books Written by Charlotte Bronte",{"$f":"SUMPRODUCT(--EXACT(\"Charlotte Bronte\",D5:D14))","v":2}]

{"sheet":"SUMPRODUCT, ISNUMBER, FIND","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Performance of SUMPRODUCT, ISNUMBER, and FIND Functions"]
[]
[null,"Book Name","Published year","Author","Genre"]
[null,"Great Expectations",1860,"Charles Dickens","Biographical Novel"]
[null,"Jane Eyre",1847,"Charlotte Bronte","Biographical Novel"]
[null,"The Return of the Native",1878,"Thomas Hardy","Social Novel"]
[null,"Shirley",1849,"Charlotte Bronte","Biographical Novel"]
[null,"To The Lighthouse",1927,"Virginia Woolf","Modernist Novel"]
[null,"The Mayor of Casterbridge",1886,"Thomas Hardy","Social Novel"]
[null,"The Catcher in the Rye",1945,"J. D. Salinger","Fiction Novel"]
[null,"Wuthering Heights",1847,"Emily Bronte","Biographical Novel"]
[null,"A Tale of Two Cities",1859,"Charles Dickens","Historical Novel"]
[null,"The Scarlet Letter",1860,"Nathaniel Hawthorne","Romantic Novel"]
[]
[null,"Books Written by Charles Dickens",{"$f":"SUMPRODUCT(--ISNUMBER(FIND(\"Dickens\",D5:D14)))","v":2}]

{"sheet":"COUNTIFS","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of COUNTIFS Function with Multiple Criteria"]
[]
[null,"Book Name","Published year","Author","Genre"]
[null,"Great Expectations",1860,"Charles Dickens","Biographical Novel"]
[null,"Jane Eyre",1847,"Charlotte Bronte","Biographical Novel"]
[null,"The Return of the Native",1878,"Thomas Hardy","Social Novel"]
[null,"Shirley",1849,"Charlotte Bronte","Biographical Novel"]
[null,"To The Lighthouse",1927,"Virginia Woolf","Modernist Novel"]
[null,"The Mayor of Casterbridge",1886,"Thomas Hardy","Social Novel"]
[null,"The Catcher in the Rye",1945,"J. D. Salinger","Fiction Novel"]
[null,"Wuthering Heights",1847,"Emily Bronte","Biographical Novel"]
[null,"A Tale of Two Cities",1859,"Charles Dickens","Historical Novel"]
[null,"The Scarlet Letter",1860,"Nathaniel Hawthorne","Romantic Novel"]
[]
[null,"Thomas Hardy Books Published after 1880",{"$f":"COUNTIFS(D5:D14,\"Thomas Hardy\",C5:C14,\">1880\")","v":1}]

{"sheet":"VBA","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Book Name","Published year","Author","Genre",null,"Choosen Genre","Count"]
[null,"Great Expectations",1860,"Charles Dickens","Biographical Novel",null,"Social Novel",2]
[null,"Jane Eyre",1847,"Charlotte Bronte","Biographical Novel"]
[null,"The Return of the Native",1878,"Thomas Hardy","Social Novel"]
[null,"Shirley",1849,"Charlotte Bronte","Biographical Novel"]
[null,"To The Lighthouse",1927,"Virginia Woolf","Modernist Novel"]
[null,"The Mayor of Casterbridge",1886,"Thomas Hardy","Social Novel"]
[null,"The Catcher in the Rye",1945,"J. D. Salinger","Fiction Novel"]
[null,"Wuthering Heights",1847,"Emily Bronte","Biographical Novel"]
[null,"A Tale of Two Cities",1859,"Charles Dickens","Historical Novel"]
[null,"The Scarlet Letter",1860,"Nathaniel Hawthorne","Romantic Novel"]