{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Overview","INDIRECT","OFFSET","INDEX","VBA"],"not_rendered":{"charts":0,"images":0,"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":"Dataset","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Grocery Items"]
[]
[null,"Serial Number","Product","Quantity","Unit Price","Total Price"]
[null,1,"Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,2,"Carrot",35,1.77,{"$f":"PRODUCT(D6,E6)","v":61.95}]
[null,3,"Chocolate Chip",57,1.87,106.59]
[null,4,"Potato Chips",25,1.68,42]
[null,5,"Bran",24,1.87,44.88]
[null,6,"Oatmeal Raisin",83,1.87,155.21]
[null,7,"Arrowroot",124,2.8400000000000003,352.16]
[null,8,"Salt",137,1.77,242.49]
[null,9,"Ice Cream",146,2.1799999999999997,318.27999999999997]
[null,10,"Milk Powder",34,1.8699999999999999,63.58]
[null,11,"Mango Juice",20,1.77,35.4]

{"sheet":"Overview","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[10,2,11,3]]}
[]
[null,"Overview of Row Number as Cell Reference"]
[]
[null,"Number","Random Cell Entry","Sum of the Number"]
[null,1,11,{"$f":"SUM(B5:INDIRECT(\"B\"&C5))","v":90}]
[null,3]
[null,7,"=INDIRECT(\"B\"&C5)",{"$f":"INDIRECT(\"B\"&C5)","v":56}]
[null,8]
[null,0]
[null,15]
[null,56,"Formula =SUM(B5:B11)\n>> Sum of the Numbers"]
[null,{"$f":"SUM(B5:B11)","v":90}]

{"sheet":"INDIRECT","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using INDIRECT Function"]
[]
[null,"Serial Number","Product","Quantity","Unit Price","Total Price"]
[null,1,"Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,2,"Carrot",35,1.77,{"$f":"PRODUCT(D6,E6)","v":61.95}]
[null,3,"Chocolate Chip",57,1.87,106.59]
[null,4,"Potato Chips",25,1.68,42]
[null,5,"Bran",24,1.87,44.88]
[null,6,"Oatmeal Raisin",83,1.87,155.21]
[null,7,"Arrowroot",124,2.8400000000000003,352.16]
[null,8,"Salt",137,1.77,242.49]
[null,9,"Ice Cream",146,2.1799999999999997,318.27999999999997]
[null,10,"Milk Powder",34,1.8699999999999999,63.58]
[null,11,"Mango Juice",20,1.77,35.4]
[null,null,null,null,"Total Cost",{"$f":"SUM(F5:INDIRECT(\"F\"&B15+4))","v":1527.24}]

{"sheet":"OFFSET","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using OFFSET Function"]
[]
[null,"Serial Number","Product","Quantity","Unit Price","Total Price"]
[null,1,"Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,2,"Carrot",35,1.77,{"$f":"PRODUCT(D6,E6)","v":61.95}]
[null,3,"Chocolate Chip",57,1.87,106.59]
[null,4,"Potato Chips",25,1.68,42]
[null,5,"Bran",24,1.87,44.88]
[null,6,"Oatmeal Raisin",83,1.87,155.21]
[null,7,"Arrowroot",124,2.8400000000000003,352.16]
[null,8,"Salt",137,1.77,242.49]
[null,9,"Ice Cream",146,2.1799999999999997,318.27999999999997]
[null,10,"Milk Powder",34,1.8699999999999999,63.58]
[null,11,"Mango Juice",20,1.77,35.4]
[null,null,null,null,"Total Cost",{"$f":" SUM(F5:OFFSET(F5, B15-1,0,1,1))","v":1527.24}]

{"sheet":"INDEX","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using INDEX Function"]
[]
[null,"Serial Number","Product","Quantity","Unit Price","Total Price"]
[null,1,"Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,2,"Carrot",35,1.77,{"$f":"PRODUCT(D6,E6)","v":61.95}]
[null,3,"Chocolate Chip",57,1.87,106.59]
[null,4,"Potato Chips",25,1.68,42]
[null,5,"Bran",24,1.87,44.88]
[null,6,"Oatmeal Raisin",83,1.87,155.21]
[null,7,"Arrowroot",124,2.8400000000000003,352.16]
[null,8,"Salt",137,1.77,242.49]
[null,9,"Ice Cream",146,2.1799999999999997,318.27999999999997]
[null,10,"Milk Powder",34,1.8699999999999999,63.58]
[null,11,"Mango Juice",20,1.77,35.4]
[null,null,null,null,"Total Cost",{"$f":"SUM(F5:INDEX(F:F,B15+4))","v":1527.24}]

{"sheet":"VBA","index":5,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA"]
[]
[null,"Serial Number","Product","Quantity","Unit Price","Total Price"]
[null,1,"Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,2,"Carrot",35,1.77,{"$f":"PRODUCT(D6,E6)","v":61.95}]
[null,3,"Chocolate Chip",57,1.87,106.59]
[null,4,"Potato Chips",25,1.68,42]
[null,5,"Bran",24,1.87,44.88]
[null,6,"Oatmeal Raisin",83,1.87,155.21]
[null,7,"Arrowroot",124,2.8400000000000003,352.16]
[null,8,"Salt",137,1.77,242.49]
[null,9,"Ice Cream",146,2.1799999999999997,318.27999999999997]
[null,10,"Milk Powder",34,1.8699999999999999,63.58]
[null,11,"Mango Juice",20,1.77,35.4]