{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Contents","Introduction COUNTIF","Basic Example","Two column SumIF","Two column SumIFS","Date Example","Multiple columns","OR","Sales-Combine","Sumif-Blank-Equal","Sumif-Blank-Blank","Sumif-Blank-NonBlank"],"not_rendered":{"charts":0,"images":2,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["SUMIF 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,"Two column SumIF",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Two column SumIFS"]
[null,"Date Example"]
[null,"Multiple columns"]
[null,"OR"]
[null,"Sales-Combine"]
[null,"Sumif-Blank-Equal"]
[null,"Sumif-Blank-Blank"]
[null,"Sumif-Blank-NonBlank"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SUMIF ",null,"=SUMIF (range, criteria, [sum_range])"]
[]
[null,"The Excel SUMIF function returns the sum of cells that meet a single condition."]
[]
[null,"Fruit","Price","Stock","Total Value"]
[null,"Apples",8,57,{"$f":"D7*C7","v":456},null,"Total Stock < 6$",null,{"$f":"SUMIF(C7:C12,\"<6\",D7:D12)","v":197}]
[null,"Bananas",5,130,{"$f":"D8*C8","v":650}]
[null,"Lemons",7,132,924,null,"Total Value < 6$",null,{"$f":"SUMIF(C7:C12,\"<6\",E7:E12)","v":918}]
[null,"Oranges",4,67,268]
[null,"Pears",8,124,992,null,"Total value Stock >= 100",null,{"$f":"SUMIF(D7:D12,\">=100\",E7:E12)","v":2566}]
[null,"Almonds",7,99,693]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Basic Example","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Recorded Sales",null,"Result"]
[4000,null,{"$f":"SUMIF(A2:A7,\">0\")","v":35000}]
[5000]
[8000]
[-7000]
[10000]
[8000]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Two column SumIF","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Items","Number picked",null,"Banana"]
["Banana",8,null,{"$f":"SUMIF(A2:A7,D1,B2:B7)","v":16}]
["Apple",4]
["Orange",10]
["Apple",10]
["Apple",4]
["Banana",8]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Two column SumIFS","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Items","Number picked",null,"Banana"]
["Banana",8,null,{"$f":"SUMIFS(B2:B7,A2:A7,D1)","v":16}]
["Apple",4]
["Orange",10]
["Apple",10]
["Apple",4]
["Banana",8]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Date Example","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Date","Visitors",null,"Start Date","End Date"]
["2020-01-01",137,null,"2020-01-01","2020-01-31"]
["2020-01-15",157]
["2020-01-29",103,null,"Formula"]
["2020-02-12",154,null,{"$f":"SUMIFS(B2:B7,A2:A7,\">=\"&D2,A2:A7,\"<=\"&E2)","v":397}]
["2020-02-26",122]
["2020-03-11",182]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Multiple columns","index":6,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Items","Date","Number picked",null,"Fruit","Start Date","End Date"]
["Banana","2020-01-01",8,null,"Apple","2020-02-01","2020-02-29"]
["Apple","2020-01-15",4]
["Orange","2020-01-29",10,null,"Formula"]
["Apple","2020-02-12",10,null,{"$f":"SUMIFS(C2:C7, B2:B7, \">=\"&F2, B2:B7, \"<=\"&G2, A2:A7, E2)","v":14}]
["Apple","2020-02-26",4]
["Banana","2020-03-11",8]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"OR","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Name","Sales",null,"Result"]
["Adam",14548,null,{"$f":"SUMIFS(B2:B7,A2:A7,\"Adam\")+SUMIFS(B2:B7,A2:A7,\"Bob\")","v":70871}]
["Bob",18514]
["Charlie",19929]
["Adam",12853]
["Bob",24956]
["Charlie",22409]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sales-Combine","index":8,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Name","Sales",null,"Result"]
["Adam",14548,null,{"$f":"SUM(SUMIFS(B2:B7,A2:A7,{\"Adam\",\"Bob\"}))","v":70871}]
["Bob",18514]
["Charlie",19929]
["Adam",12853]
["Bob",24956]
["Charlie",22409]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sumif-Blank-Equal","index":9,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Fruit","Count",null,"Result"]
["Apple",5,null,{"$f":"SUMIFS(B2:B7,A2:A7,\"=\")","v":3}]
[null,1]
["Banana",10]
[null,2]
["Pineapple",20]
["Watermelon",30]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sumif-Blank-Blank","index":10,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Fruit","Count",null,"Result"]
["Apple",5,null,{"$f":"SUMIFS(B2:B7,A2:A7,\"\")","v":3}]
[null,1]
["Banana",10]
[null,2]
["Pineapple",20]
["Watermelon",30]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sumif-Blank-NonBlank","index":11,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Fruit","Count",null,"Result"]
["Apple",5,null,{"$f":"SUMIFS(B2:B7,A2:A7,\"<>\")","v":65}]
[null,1]
["Banana",10]
[null,2]
["Pineapple",20]
["Watermelon",30]
[]
[null,"automateexcel.com/functions/sumif-countif-averageif-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]