{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Contents","Introduction SUMPRODUCT","SUMPRODUCT","Weighted Average","SumProduct-Three-Columns","One criteria","Multiple criteria","Complex criteria","Two dimensions","RED","A","Two dimensions Complex","SUMPRODUCT Or","SUMPRODUCT Exact"],"not_rendered":{"charts":0,"images":2,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["SUMPRODUCT Function"]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction SUMPRODUCT",null,null,null,"Excel Formulas w/Examples"]
[null,"SUMPRODUCT",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Weighted Average",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"SumProduct-Three-Columns"]
[null,"One criteria"]
[null,"Multiple criteria"]
[null,"Complex criteria"]
[null,"Two dimensions"]
[null,"RED"]
[null,"A"]
[null,"Two dimensions Complex"]
[null,"SUMPRODUCT Or"]
[null,"SUMPRODUCT Exact"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 SUMPRODUCT","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[11,3,11,4],[12,3,12,4]]}
[]
[null,"SUMPRODUCT",null,"=SUMPRODUCT (array1, [array2], ...)"]
[]
[null,"The SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products"]
[]
[null,"Item","Size","SOLD","Price ($)"]
[null,"AAA","S",45,10]
[null,"BBB","M",21,20]
[null,"AAA","S",20,65]
[null,"BBB","M",41,40]
[]
[null,"Item","Size","TOTAL_Value"]
[null,"AAA","S",{"$f":"SUMPRODUCT((B7:B10=B13)*(C7:C10=C13)*D7:D10,E7:E10)","v":1750}]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"SUMPRODUCT","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Units Sold","Price",null,"Result"]
[100,6,null,{"$f":"SUMPRODUCT(A2:A4,B2:B4)","v":1000}]
[50,7]
[10,5]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Weighted Average","index":3,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Item","Weight","Grade"]
["Quizes",0.3,0.73,null,{"$f":"SUMPRODUCT(B2:B4, C2:C4)","v":0.85899999999999999}]
["Tests",0.5,0.9]
["HW",0.2,0.95]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"SumProduct-Three-Columns","index":4,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Item","Pack Size","Qty","Price",null,"Result"]
["Lumber A",4,2,1,null,{"$f":"SUMPRODUCT(B2:B5,C2:C5,D2:D5)","v":72}]
["Lumber B",4,2,2]
["Lumber C",4,4,1]
["Lumber D",4,4,2]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"One criteria","index":5,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Units Sold","Type",null,"Result"]
[100,"Red",null,{"$f":"SUMPRODUCT(A2:A4, --(B2:B4=\"Red\"))","v":150}]
[50,"Red"]
[10,"Blue"]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Multiple criteria","index":6,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Units Sold","Type","Month",null,"Result"]
[100,"Red","Jan",null,{"$f":"SUMPRODUCT(A2:A4, --(B2:B4=\"Red\"), --(C2:C4=\"Feb\"))","v":50}]
[50,"Red","Feb"]
[10,"Blue","Feb"]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Complex criteria","index":7,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Units Sold","Type","Month",null,"Result"]
[100,"Red","2020-01-01",null,{"$f":"SUMPRODUCT(A2:A4, --(B2:B4=\"Red\"), --(MONTH(C2:C4)=2))","v":50}]
[50,"Red","2020-02-04"]
[10,"Blue","2020-02-04"]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Two dimensions","index":8,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Type","A","B",null,"Result"]
["Red",5,7,null,{"$f":"SUMPRODUCT((A2:A4=\"Red\")*(B1:C1=\"A\")*B2:C4)","v":15}]
["Red",10,9]
["Blue",8,4]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"RED","index":9,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Type","A","B",null,"Result"]
["Red",5,7,null,{"$f":"SUMPRODUCT((A2:A4=\"Red\")*B2:C4)","v":31}]
["Red",10,9]
["Blue",8,4]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"A","index":10,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Item","SOLD","Color","Catogory",null,"Result"]
["AAA",100,"RED","A",null,{"$f":"SUMPRODUCT(B2:B4*(D2:D4=\"A\"))","v":110}]
["BBB",50,"RED","B"]
["CCC",10,"Green","A"]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Two dimensions Complex","index":11,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Name","Jan Items","Jan Sales","Feb Items","Feb Sales",null,"Result"]
["Adam",2,500,5,800,null,{"$f":"SUMPRODUCT((A2:A5=\"Bob\")*(ISNUMBER(SEARCH(\"Items\",B1:E1))*B2:E5))","v":29}]
["Bob",10,800,7,700]
["Adam",7,800,3,500]
["Bob",5,600,7,1000]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"SUMPRODUCT Or","index":12,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Units Sold","Type",null,"Result"]
[100,"Red",null,{"$f":"SUMPRODUCT(A2:A7, (B2:B7=\"Red\")+(B2:B7=\"Blue\"))","v":235}]
[50,"Red"]
[10,"Blue"]
[200,"Green"]
[75,"Blue"]
[20,"Green"]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"SUMPRODUCT Exact","index":13,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Item","Score",null,"Result"]
["abc123",5,null,{"$f":"SUMPRODUCT(--EXACT(\"ABC123\", A2:A5), B2:B5)","v":2}]
["ABC123",2]
["def456",6]
["DEF456",7]
[]
[null,"automateexcel.com/functions/sumproduct-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]