{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Problem","SUBTOTAL","Table","AGGREGATE","Using Formulas","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Problem","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sum Filtered Cells"]
[]
[null,"Fruit Name"," Amount (KG)"]
[null,"Orange",3000]
[null,"Apple",4000]
[null,"Pear",2500]
[null,"Banana",3500]
[null,"Peach",4000]
[null,"Mango",5000]
[null,"Pineapple",3000]
[null,"Apple",3000]
[null,"Plum",2000]
[null,"Plum",3000]

{"sheet":"SUBTOTAL","index":1,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using SUBTOTAL Function",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Fruit Name"," Amount (KG)",null,null,null,null,null,null,"Fruit Name"," Amount (KG)"]
[null,"Orange",3000,null,null,null,null,null,null,"Orange",3000]
[null,"Apple",4000,null,null,null,null,null,null,"Apple",4000]
[null,"Pear",2500,null,null,null,null,null,null,"Pear",2500]
[null,"Banana",3500,null,null,null,null,null,null,"Banana",3500]
[null,"Peach",4000,null,null,null,null,null,null,"Peach",4000]
[null,"Mango",5000,null,null,null,null,null,null,"Mango",5000]
[null,"Pineapple",3000,null,null,null,null,null,null,"Pineapple",3000]
[null,"Apple",3000,null,null,null,null,null,null,"Apple",3000]
[null,"Plum",2000,null,null,null,null,null,null,"Plum",2000]
[null,"Plum",3000,null,null,null,null,null,null,"Plum",3000]
[]
[null,"Total",{"$f":"SUBTOTAL(9,C5:C14)","v":33000},null,null,null,null,null,null,"Total"]

{"sheet":"Table","index":2,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Creating Table",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Fruit Name"," Amount (KG)",null,null,null,null,null,null,"Fruit Name"," Amount (KG)"]
[null,"Orange",3000,null,null,null,null,null,null,"Orange",3000]
[null,"Apple",4000,null,null,null,null,null,null,"Apple",4000]
[null,"Pear",2500,null,null,null,null,null,null,"Pear",2500]
[null,"Banana",3500,null,null,null,null,null,null,"Banana",3500]
[null,"Peach",4000,null,null,null,null,null,null,"Peach",4000]
[null,"Mango",5000,null,null,null,null,null,null,"Mango",5000]
[null,"Pineapple",3000,null,null,null,null,null,null,"Pineapple",3000]
[null,"Apple",3000,null,null,null,null,null,null,"Apple",3000]
[null,"Plum",2000,null,null,null,null,null,null,"Plum",2000]
[null,"Plum",3000,null,null,null,null,null,null,"Plum",3000]
[null,"Total",{"$f":"SUBTOTAL(109,Table[ Amount (KG)])","v":33000}]

{"sheet":"AGGREGATE","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using AGGREGATE Function",null,null,null,null,null,null,"For Practice"]
[]
[null,"Fruit Name"," Amount (KG)",null,null,null,null,null,"Fruit Name"," Amount (KG)"]
[null,"Orange",3000,null,null,null,null,null,"Orange",3000]
[null,"Apple",4000,null,null,null,null,null,"Apple",4000]
[null,"Pear",2500,null,null,null,null,null,"Pear",2500]
[null,"Banana",3500,null,null,null,null,null,"Banana",3500]
[null,"Peach",4000,null,null,null,null,null,"Peach",4000]
[null,"Mango",5000,null,null,null,null,null,"Mango",5000]
[null,"Pineapple",3000,null,null,null,null,null,"Pineapple",3000]
[null,"Apple",3000,null,null,null,null,null,"Apple",3000]
[null,"Plum",2000,null,null,null,null,null,"Plum",2000]
[null,"Plum",3000,null,null,null,null,null,"Plum",3000]
[]
[null,"Total",{"$f":"_xlfn.AGGREGATE(9,5,B5:C14)","v":33000},null,null,null,null,null,"Total"]

{"sheet":"Using Formulas","index":4,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using Formulas",null,null,null,null,null,null,"For Practice"]
[]
[null,"Fruit Name"," Amount (KG)",null,null,null,null,null,"Fruit Name"," Amount (KG)"]
[null,"Orange",3000,null,null,null,null,null,"Orange",3000]
[null,"Apple",4000,null,null,null,null,null,"Apple",4000]
[null,"Pear",2500,null,null,null,null,null,"Pear",2500]
[null,"Banana",3500,null,null,null,null,null,"Banana",3500]
[null,"Peach",4000,null,null,null,null,null,"Peach",4000]
[null,"Mango",5000,null,null,null,null,null,"Mango",5000]
[null,"Pineapple",3000,null,null,null,null,null,"Pineapple",3000]
[null,"Apple",3000,null,null,null,null,null,"Apple",3000]
[null,"Plum",2000,null,null,null,null,null,"Plum",2000]
[null,"Plum",3000,null,null,null,null,null,"Plum",3000]
[]
[null,"Chosen Fruit","Apple",null,null,null,null,null,"Chosen Fruit"]
[null,"Total",{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET(B5:B14,ROW(B5:B14)-MIN(ROW(B5:B14)),,1)),( B5:B14=C16)*(C5:C14))","v":7000},null,null,null,null,null,"Total"]

{"sheet":"VBA","index":5,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using VBA",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Fruit Name"," Amount (KG)",null,null,null,null,null,null,"Fruit Name"," Amount (KG)"]
[null,"Orange",3000,null,null,null,null,null,null,"Orange",3000]
[null,"Apple",4000,null,null,null,null,null,null,"Apple",4000]
[null,"Pear",2500,null,null,null,null,null,null,"Pear",2500]
[null,"Banana",3500,null,null,null,null,null,null,"Banana",3500]
[null,"Peach",4000,null,null,null,null,null,null,"Peach",4000]
[null,"Mango",5000,null,null,null,null,null,null,"Mango",5000]
[null,"Pineapple",3000,null,null,null,null,null,null,"Pineapple",3000]
[null,"Apple",3000,null,null,null,null,null,null,"Apple",3000]
[null,"Plum",2000,null,null,null,null,null,null,"Plum",2000]
[null,"Plum",3000,null,null,null,null,null,null,"Plum",3000]
[]
[null,"Total",{"$f":"Sum_Filtered_Cells(C5:C14)","v":33000},null,null,null,null,null,null,"Total"]