{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Contents","Introduction COUNTIF","Basic Example","Search-5","Search-Balnk","Serch-text","Partial Match Apple","Partial Match Pie","5 or Older","Less Than 8","Not 6","Less Than 7","Dates","Dates-may-7","Multiple criteria","Unique-Value","COUNTIFS"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["COUNTIF Function"]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction COUNTIF",null,null,null,"Excel Formulas w/Examples"]
[null,"Basic Example",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Search-5",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Search-Balnk"]
[null,"Serch-text"]
[null,"Partial Match Apple"]
[null,"Partial Match Pie"]
[null,"5 or Older"]
[null,"Less Than 8"]
[null,"Not 6"]
[null,"Less Than 7"]
[null,"Dates"]
[null,"Dates-may-7"]
[null,"Multiple criteria"]
[null,"Unique-Value"]
[null,"COUNTIFS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Introduction COUNTIF","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COUNTIF",null,"=COUNTIF (range, criteria)"]
[null,"COUNTIF is a function to count cells that meet a single criterion. "]
[null,"COUNTIF can be used to count cells with dates, numbers, and text that meet specific criteria."]
[]
[null,"Fruit","Price ($)","Stock"]
[null,"Apples",8,121,null,"Count no of Fruits",null,{"$f":"COUNTIF(B7:B12,\"<>\")","v":6}]
[null,"Bananas",5,130]
[null,"Lemons",7,132,null,"No of Item < 6$",null,{"$f":"COUNTIF(C7:C12,\"<6\")","v":2}]
[null,"Oranges",5,146]
[null,"Pears",8,124,null,"No of Item Stock >= 130",null,{"$f":"COUNTIF(D7:D12,\">130\")","v":3}]
[null,"Almonds",7,146]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Basic Example","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["List of Data",null,"Search for:"]
["Apple",null,"Apple"]
["Banana",null,"Result"]
[5,null,{"$f":"COUNTIF(A2:A9,#REF!)","v":0}]
[5]
["Apple"]
["Apple"]
[]
[15]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Search-5","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["List of Data",null,"Search for:"]
["Apple",null,5]
["Banana",null,"Result"]
[5,null,{"$f":"COUNTIF(A2:A9,5)","v":2}]
[5]
["Apple"]
["Apple"]
[]
[15]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Search-Balnk","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["List of Data",null,"Search for:"]
["Apple",null,"Blank"]
["Banana",null,"Result"]
[5,null,{"$f":"COUNTIF(A2:A9,\"\")","v":1}]
[5]
["Apple"]
["Apple"]
[]
[15]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Serch-text","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["List of Data",null,"Search for:"]
["Apple",null,"TEXT"]
["Banana",null,"Result"]
[5,null,{"$f":"COUNTIF(A2:A9,\"*\")","v":4}]
[5]
["Apple"]
["Apple"]
[]
[15]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Partial Match Apple","index":6,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Bakery goods",null,"Starts apple"]
["Apple pie",null,{"$f":"COUNTIF(A2:A8,\"Apple*\")","v":3}]
["Apple tart"]
["Apple juice"]
["Strawberry pie"]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Partial Match Pie","index":7,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Bakery goods",null,"Ends pie"]
["Apple pie",null,{"$f":"COUNTIF(A2:A5,\"*pie\")","v":2}]
["Apple tart"]
["Apple juice"]
["Strawberry pie"]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"5 or Older","index":8,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Ages",null,"5 or older"]
[9,null,{"$f":"COUNTIF(A2:A8,\">=5\")","v":4}]
[5]
[4]
[6]
[4]
[8]
[1]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Less Than 8","index":9,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Ages",null,"Less than 8"]
[9,null,{"$f":"COUNTIF(A2:A8,\"<8\")","v":5}]
[5]
[4]
[6]
[4]
[8]
[1]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Not 6","index":10,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Ages",null,"Not 6"]
[9,null,{"$f":"COUNTIF(A2:A8,\"<>6\")","v":6}]
[5]
[4]
[6]
[4]
[8]
[1]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Less Than 7","index":11,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Ages",null,"Less than:","Output"]
[9,null,7,{"$f":"COUNTIF(A2:A8,\"<\"&C2)","v":5}]
[5]
[4]
[6]
[4]
[8]
[1]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Dates","index":12,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["My Calendar",null,"Date hard coded",null,null,"Find dates before:"]
["2020-05-01",null,{"$f":"COUNTIF(A2:A9, \"<May 4\")","v":4},null,null,"2020-05-07"]
["2020-05-02",null,null,null,null,"Formula"]
["2020-05-03",null,null,null,null,{"$f":"COUNTIF(A2:A9,\"<\"&F2)","v":7}]
["2020-05-04"]
["2020-05-05"]
["2020-05-06"]
["2019-03-01"]
["2021-01-01"]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Dates-may-7","index":13,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["My Calendar",null,"Find dates before:"]
["2020-05-01",null,"2020-05-07"]
["2020-05-02",null,"Formula"]
["2020-05-03",null,{"$f":"COUNTIF(A2:A9,\"<\"&C2)","v":7}]
["2020-05-04"]
["2020-05-05"]
["2020-05-06"]
["2019-03-01"]
["2021-01-01"]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Multiple criteria","index":14,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Department","Pay Level",null,"In HR or Management?"]
["HR",1,null,{"$f":"SUM(COUNTIF(A2:A7, {\"HR\",\"Management\"}))","v":5}]
["HR",2]
["Management",1]
["Management",1]
["Management",2]
["Sales",3]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Unique-Value","index":15,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Department",null,"Unique values"]
["HR",null,{"$f":"SUM(1/COUNTIF(A2:A7,A2:A7))","v":3}]
["HR"]
["Management"]
["Management"]
["Management"]
["Sales"]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"COUNTIFS","index":16,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,4,2,4],[1,6,2,6]]}
["Fruit","Price ($)","Stock"]
["Apples",8,121,null,"Count no of Fruits (Criteria Price < 6$ and  Stock >= 130)",null,{"$f":"COUNTIFS(B2:B7,\"<6\",C2:C7,\">=130\")","v":2}]
["Bananas",5,130]
["Lemons",7,132]
["Oranges",5,146]
["Pears",8,124]
["Almonds",7,146]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"DATEDIF(M14"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(start_date, end_date, unit)"]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]