{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Contents","Introduction SUBTOTAL","SUBTOTAL","9 Vs 109","9 Vs 109 AutoFilter","9 Vs 109 ManualFilter","Changing Operation","Changing Operation NEW","IF-Subtotal (2)","Conditional formulas","Conditional Check"],"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":[]}
["SUBTOTAL Function"]
[null,"automateexcel.com/functions/subtotal-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction SUBTOTAL",null,null,null,"Excel Formulas w/Examples"]
[null,"SUBTOTAL",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"9 Vs 109",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"9 Vs 109 AutoFilter"]
[null,"9 Vs 109 ManualFilter"]
[null,"Changing Operation"]
[null,"Changing Operation NEW"]
[null,"IF-Subtotal (2)"]
[null,"Conditional formulas"]
[null,"Conditional Check"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 SUBTOTAL","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,3,17,4],[18,3,18,4]]}
[]
[null,"SUBTOTAL",null,"=SUBTOTAL (function_num, ref1, [ref2], ...)"]
[null,"The SUBTOTAL function returns an aggregate result for supplied values. SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, Etc."]
[]
[null,"Item","Categary","Qantity (KG)","Unit Price","Total Value"]
[null,"Bananas","fruit",170,8,{"$f":"D6*E6","v":1360}]
[null,"Dragon Fruit","fruit",168,7,{"$f":"D7*E7","v":1176}]
[null,"Apricots","fruit",103,10,1030]
[null,"ABA","Others",189,7,1323]
[null,"XXX","Others",86,10,860]
[null,"Apple","fruit",180,9,1620]
[null,"Kiwi","fruit",200,8,1600]
[null,"BBB","Others",183,7,1281]
[null,"Honeydew melon","fruit",107,6,642]
[null,"AAA","Others",110,9,990]
[null,"Apricots","fruit",95,5,475]
[]
[null,"Categary","Total Qty","TOTAL Value"]
[null,"Others",{"$f":"SUBTOTAL(9,D6:D16)","v":1591},{"$f":"SUBTOTAL(9,F6:F16)","v":12357}]
[]
[null,"automateexcel.com/functions/subtotal-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"SUBTOTAL","index":2,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Fruit","Qty"]
["Apple",3]
["Apple",6]
["Apple",4]
["Apple Total",{"$f":"SUBTOTAL(9,B2:B4)","v":13}]
["Banana",5]
["Banana",5]
["Banana Total",{"$f":"SUBTOTAL(9,B6:B7)","v":10}]
["Overall Total",{"$f":"SUBTOTAL(9,B2:B8)","v":23}]
[]
[null,"automateexcel.com/functions/subtotal-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"9 Vs 109","index":3,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Fruit","Qty",null,"SUBTOTAL_9","SUBTOTAL_109"]
["Apple",3,null,{"$f":"SUBTOTAL(9,B2:B6)","v":23},{"$f":"SUBTOTAL(109,B2:B6)","v":23},null,"=SUBTOTAL(109,B2:B6)"]
["Apple",6]
["Apple",4]
["Banana",5]
["Banana",5]
[]
[null,"automateexcel.com/functions/subtotal-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"9 Vs 109 AutoFilter","index":4,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Fruit","Qty",null,"SUBTOTAL_9","SUBTOTAL_109"]
["Apple",3,null,{"$f":"SUBTOTAL(9,B2:B6)","v":13},{"$f":"SUBTOTAL(109,B2:B6)","v":13},null,"=SUBTOTAL(109,B2:B6)"]
["Apple",6]
["Apple",4]
["Banana",5]
["Banana",5]
[]
[null,"automateexcel.com/functions/subtotal-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"9 Vs 109 ManualFilter","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Fruit","Qty",null,"SUBTOTAL_9","SUBTOTAL_109"]
["Apple",3,null,{"$f":"SUBTOTAL(9,B2:B6)","v":23},{"$f":"SUBTOTAL(109,B2:B6)","v":13},null,"=SUBTOTAL(109,B2:B6)"]
["Apple",6]
["Apple",4]
["Banana",5]
["Banana",5]
[]
[null,"automateexcel.com/functions/subtotal-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Changing Operation","index":6,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Fruit","Qty",null,"Requirment","Result",null,"Average",1]
["Apple",3,null,"Sum",{"$f":"SUBTOTAL(VLOOKUP(D2,G1:H4,2,FALSE),B2:B5)","v":13},null,"Max",4]
["Apple",6,null,null,null,null,"Min",5]
["Apple",4,null,null,null,null,"Sum",9]
["Sum",{"$f":"SUBTOTAL(IF(A5=\"Average\",1,IF(A5=\"Sum\",9)),B2:B4)","v":13}]
[]
[null,"automateexcel.com/functions/subtotal-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Changing Operation NEW","index":7,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Fruit","Qty",null,"Requirment","Result",null,"Average",1]
["Apple",3,null,"Sum",{"$f":"SUBTOTAL(IF(D2=\"Average\",1,IF(D2=\"Sum\",9)),B2:B4)","v":13},null,"Max",4]
["Apple",6,null,null,null,null,"Min",5]
["Apple",4,null,null,null,null,"Sum",9]
[]
[null,"automateexcel.com/functions/subtotal-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"IF-Subtotal (2)","index":8,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Fruit","Qty",null,"Requirment","Result",null,"Average",1]
["Apple",3,null,"Sum",{"$f":"SUBTOTAL(VLOOKUP(D2,G1:H4,2,FALSE),B2:B4)","v":13},null,"Max",4]
["Apple",6,null,null,null,null,"Min",5]
["Apple",4,null,null,null,null,"Sum",9]
[]
[null,"automateexcel.com/functions/subtotal-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Conditional formulas","index":9,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Fruit","Qty","Helper",null,"Result"]
["Apple",3,1,null,{"$f":"SUMIFS(B2:B6,A2:A6,\"Apple\",C2:C6,1)","v":607}]
["Apple",600,1]
["Apple",4,1]
["Banana",5,1]
["Banana",50,1]
[]
[null,"automateexcel.com/functions/subtotal-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Conditional Check","index":10,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Fruit","Qty","Helper",null,"Result:",{"$f":"SUMIFS(B:B,A:A,\"Apple\",C:C,1)","v":607}]
["Apple",3,{"$f":"SUBTOTAL(103,A2)","v":1}]
["Apple",600,{"$f":"SUBTOTAL(103,A3)","v":1}]
["Apple",4,1]
["Banana",5,1]
["Banana",50,1]
[]
[null,"automateexcel.com/functions/subtotal-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]