{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Jan","Feb","Mar","Apr","May","Jun","Consolidate","Sum Using Cell Ref","3D Formula Sum","INDIRECT SUM","Pull Same Cell (INDIRECT)"],"not_rendered":{"charts":0,"images":0,"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":"Jan","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Order Details of January"]
[]
[null,"Customer","Qty (Nos.)"]
[null,"Mr. Johnson",10000]
[null,"Mr. Smith",19000]
[null,"Ms. Lily",1500]
[null,"Mrs. Jackson",9000]
[null,"Mr. Howard",5000]
[null,"Mr. Musk",6600]
[null,"Mr. Gates",8000]
[null,"Mr. Lorry",20000]
[null,"Total Order",{"$f":"SUM(C5:C12)","v":79100}]

{"sheet":"Feb","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Order Details of February"]
[]
[null,"Customer","Qty (Nos.)"]
[null,"Mr. Johnson",9000]
[null,"Mr. Smith",15000]
[null,"Ms. Lily",2000]
[null,"Mrs. Jackson",8500]
[null,"Mr. Howard",4500]
[null,"Mr. Musk",15000]
[null,"Mr. Gates",8000]
[null,"Mr. Lorry",21000]
[null,"Total Order",{"$f":"SUM(C5:C12)","v":83000}]

{"sheet":"Mar","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Order Details of March"]
[]
[null,"Customer","Qty (Nos.)"]
[null,"Mr. Johnson",14000]
[null,"Mr. Smith",18000]
[null,"Ms. Lily",2000]
[null,"Mrs. Jackson",8000]
[null,"Mr. Howard",3000]
[null,"Mr. Musk",20000]
[null,"Mr. Gates",10000]
[null,"Mr. Lorry",20500]
[null,"Total Order",{"$f":"SUM(C5:C12)","v":95500}]

{"sheet":"Apr","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Order Details of April"]
[]
[null,"Customer","Qty (Nos.)"]
[null,"Mr. Johnson",13200]
[null,"Mr. Smith",20000]
[null,"Ms. Lily",2500]
[null,"Mrs. Jackson",10000]
[null,"Mr. Howard",6000]
[null,"Mr. Musk",30000]
[null,"Mr. Gates",18000]
[null,"Mr. Lorry",22000]
[null,"Total Order",{"$f":"SUM(C5:C12)","v":121700}]

{"sheet":"May","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Order Details of May"]
[]
[null,"Customer","Qty (Nos.)"]
[null,"Mr. Johnson",5000]
[null,"Mr. Smith",22000]
[null,"Ms. Lily",4000]
[null,"Mrs. Jackson",10000]
[null,"Mr. Howard",8000]
[null,"Mr. Musk",35000]
[null,"Mr. Gates",25000]
[null,"Mr. Lorry",23000]
[null,"Total Order",{"$f":"SUM(C5:C12)","v":132000}]

{"sheet":"Jun","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Order Details of June"]
[]
[null,"Customer","Qty (Nos.)"]
[null,"Mr. Johnson",8000]
[null,"Mr. Smith",45000]
[null,"Ms. Lily",3500]
[null,"Mrs. Jackson",9500]
[null,"Mr. Howard",5000]
[null,"Mr. Musk",32000]
[null,"Mr. Gates",20000]
[null,"Mr. Lorry",23000]
[null,"Total Order",{"$f":"SUM(C5:C12)","v":146000}]

{"sheet":"Consolidate","index":6,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,7,3,8]]}
[]
[null,"Using Consolidate Feature"]
[]
[null,"Customer","Qty","Unit Price","Total Price",null,null,"Practice Here!"]
[null,"Mr. Johnson",59200,10,{"$f":"C5*D5","v":592000}]
[null,"Mr. Smith",139000,12,{"$f":"C6*D6","v":1668000},null,null,"Customer","Qty"]
[null,"Ms. Lily",15500,45,697500]
[null,"Mrs. Jackson",55000,22,1210000]
[null,"Mr. Howard",31500,14,441000]
[null,"Mr. Musk",138600,20,2772000]
[null,"Mr. Gates",89000,22,1958000]
[null,"Mr. Lorry",129500,58,7511000]

{"sheet":"Sum Using Cell Ref","index":7,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,9,3,10]]}
[]
[null,"Using Cell Reference"]
[]
[null,"Customer","Qty","Unit Price","Total Price","Formula",null,null,null,"Practice Here!"]
[null,"Mr. Johnson",{"$f":"Jan!C5+Feb!C5+Mar!C5+Apr!C5+May!C5+Jun!C5","v":59200},10,{"$f":"C5*D5","v":592000},"=Jan!C5+Feb!C5+Mar!C5+\nApr!C5+May!C5+Jun!C5"]
[null,"Mr. Smith",{"$f":"Jan!C6+Feb!C6+Mar!C6+Apr!C6+May!C6+Jun!C6","v":139000},12,{"$f":"C6*D6","v":1668000},"=Jan!C6+Feb!C6+Mar!C6+Apr!C6+May!C6+Jun!C6",null,null,null,"Customer","Qty"]
[null,"Ms. Lily",{"$f":"Jan!C7+Feb!C7+Mar!C7+Apr!C7+May!C7+Jun!C7","v":15500},45,697500,"=Jan!C7+Feb!C7+Mar!C7+Apr!C7+May!C7+Jun!C7",null,null,null,"Mr. Johnson"]
[null,"Mrs. Jackson",{"$f":"Jan!C8+Feb!C8+Mar!C8+Apr!C8+May!C8+Jun!C8","v":55000},22,1210000,"=Jan!C8+Feb!C8+Mar!C8+Apr!C8+May!C8+Jun!C8",null,null,null,"Mr. Smith"]
[null,"Mr. Howard",{"$f":"Jan!C9+Feb!C9+Mar!C9+Apr!C9+May!C9+Jun!C9","v":31500},14,441000,"=Jan!C9+Feb!C9+Mar!C9+Apr!C9+May!C9+Jun!C9",null,null,null,"Ms. Lily"]
[null,"Mr. Musk",{"$f":"Jan!C10+Feb!C10+Mar!C10+Apr!C10+May!C10+Jun!C10","v":138600},20,2772000,"=Jan!C10+Feb!C10+Mar!C10+Apr!C10+May!C10+Jun!C10",null,null,null,"Mrs. Jackson"]
[null,"Mr. Gates",{"$f":"Jan!C11+Feb!C11+Mar!C11+Apr!C11+May!C11+Jun!C11","v":89000},22,1958000,"=Jan!C11+Feb!C11+Mar!C11+Apr!C11+May!C11+Jun!C11",null,null,null,"Mr. Howard"]
[null,"Mr. Lorry",{"$f":"Jan!C12+Feb!C12+Mar!C12+Apr!C12+May!C12+Jun!C12","v":129500},58,7511000,"=Jan!C12+Feb!C12+Mar!C12+Apr!C12+May!C12+Jun!C12",null,null,null,"Mr. Musk"]
[null,null,null,null,null,null,null,null,null,"Mr. Gates"]
[null,null,null,null,null,null,null,null,null,"Mr. Lorry"]

{"sheet":"3D Formula Sum","index":8,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,10,3,11]]}
[]
[null,"Using a 3D Formula"]
[]
[null,"Customer","Qty","Unit Price","Total Price","Formula",null,null,null,null,"Practice Here!"]
[null,"Mr. Johnson",{"$f":"SUM(Jan:Jun!C5)","v":59200},10,{"$f":"C5*D5","v":592000},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=SUM(Jan:Jun!C5)"}]
[null,"Mr. Smith",{"$f":"SUM(Jan:Jun!C6)","v":139000},12,{"$f":"C6*D6","v":1668000},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=SUM(Jan:Jun!C6)"},null,null,null,null,"Customer","Qty"]
[null,"Ms. Lily",{"$f":"SUM(Jan:Jun!C7)","v":15500},45,697500,"=SUM(Jan:Jun!C7)",null,null,null,null,"Mr. Johnson"]
[null,"Mrs. Jackson",{"$f":"SUM(Jan:Jun!C8)","v":55000},22,1210000,"=SUM(Jan:Jun!C8)",null,null,null,null,"Mr. Smith"]
[null,"Mr. Howard",{"$f":"SUM(Jan:Jun!C9)","v":31500},14,441000,"=SUM(Jan:Jun!C9)",null,null,null,null,"Ms. Lily"]
[null,"Mr. Musk",{"$f":"SUM(Jan:Jun!C10)","v":138600},20,2772000,"=SUM(Jan:Jun!C10)",null,null,null,null,"Mrs. Jackson"]
[null,"Mr. Gates",{"$f":"SUM(Jan:Jun!C11)","v":89000},22,1958000,"=SUM(Jan:Jun!C11)",null,null,null,null,"Mr. Howard"]
[null,"Mr. Lorry",{"$f":"SUM(Jan:Jun!C12)","v":129500},58,7511000,"=SUM(Jan:Jun!C12)",null,null,null,null,"Mr. Musk"]
[null,null,null,null,null,null,null,null,null,null,"Mr. Gates"]
[null,null,null,null,null,null,null,null,null,null,"Mr. Lorry"]

{"sheet":"INDIRECT SUM","index":9,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[5,10,5,11]]}
[]
[null,"T-Shirt Order Details"]
[]
[null,"Customer","Qty","Unit Price","Total Price"]
[null,"Mr. Johnson",{"$f":"SUM(INDIRECT($G$5:$G$10&\"!\"&CELL(\"address\",C5)))","v":59200},10,{"$f":"C5*D5","v":592000},null,"Jan"]
[null,"Mr. Smith",{"$f":"SUM(INDIRECT($G$5:$G$10&\"!\"&CELL(\"address\",C6)))","v":139000},12,{"$f":"C6*D6","v":1668000},null,"Feb",null,null,null,"Practice Here!"]
[null,"Ms. Lily",{"$f":"SUM(INDIRECT($G$5:$G$10&\"!\"&CELL(\"address\",C7)))","v":15500},45,697500,null,"Mar"]
[null,"Mrs. Jackson",{"$f":"SUM(INDIRECT($G$5:$G$10&\"!\"&CELL(\"address\",C8)))","v":55000},22,1210000,null,"Apr",null,null,null,"Customer","Qty"]
[null,"Mr. Howard",{"$f":"SUM(INDIRECT($G$5:$G$10&\"!\"&CELL(\"address\",C9)))","v":31500},14,441000,null,"May",null,null,null,"Mr. Johnson"]
[null,"Mr. Musk",{"$f":"SUM(INDIRECT($G$5:$G$10&\"!\"&CELL(\"address\",C10)))","v":138600},20,2772000,null,"Jun",null,null,null,"Mr. Smith"]
[null,"Mr. Gates",{"$f":"SUM(INDIRECT($G$5:$G$10&\"!\"&CELL(\"address\",C11)))","v":89000},22,1958000,null,null,null,null,null,"Ms. Lily"]
[null,"Mr. Lorry",{"$f":"SUM(INDIRECT($G$5:$G$10&\"!\"&CELL(\"address\",C12)))","v":129500},58,7511000,null,null,null,null,null,"Mrs. Jackson"]
[null,null,null,null,null,null,null,null,null,null,"Mr. Howard"]
[null,null,null,null,null,null,null,null,null,null,"Mr. Musk"]
[null,null,null,null,null,null,null,null,null,null,"Mr. Gates"]
[null,null,null,null,null,null,null,null,null,null,"Mr. Lorry"]

{"sheet":"Pull Same Cell (INDIRECT)","index":10,"n_rows":13,"n_cols":25,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,18,2,24]]}
[]
[null,"Using INDIRECT and CELL Functions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Here!"]
[null,"Customer","January","February","March","April","May","June","Total Order"]
[null,"Mr. Johnson",{"$f":"INDIRECT(K$5&\"!\"&CELL(\"address\",$C5))","v":10000},{"$f":"INDIRECT(L$5&\"!\"&CELL(\"address\",$C5))","v":9000},{"$f":"INDIRECT(M$5&\"!\"&CELL(\"address\",$C5))","v":14000},{"$f":"INDIRECT(N$5&\"!\"&CELL(\"address\",$C5))","v":13200},{"$f":"INDIRECT(O$5&\"!\"&CELL(\"address\",$C5))","v":5000},{"$f":"INDIRECT(P$5&\"!\"&CELL(\"address\",$C5))","v":8000},{"$f":"SUM(C5:H5)","v":59200},null,"Jan","Feb","Mar","Apr","May","Jun",null,null,"Customer","January","February","March","April","May","June"]
[null,"Mr. Smith",{"$f":"INDIRECT(K$5&\"!\"&CELL(\"address\",$C6))","v":19000},{"$f":"INDIRECT(L$5&\"!\"&CELL(\"address\",$C6))","v":15000},{"$f":"INDIRECT(M$5&\"!\"&CELL(\"address\",$C6))","v":18000},{"$f":"INDIRECT(N$5&\"!\"&CELL(\"address\",$C6))","v":20000},{"$f":"INDIRECT(O$5&\"!\"&CELL(\"address\",$C6))","v":22000},{"$f":"INDIRECT(P$5&\"!\"&CELL(\"address\",$C6))","v":45000},{"$f":"SUM(C6:H6)","v":139000},null,null,null,null,null,null,null,null,null,"Mr. Johnson"]
[null,"Ms. Lily",{"$f":"INDIRECT(K$5&\"!\"&CELL(\"address\",$C7))","v":1500},{"$f":"INDIRECT(L$5&\"!\"&CELL(\"address\",$C7))","v":2000},{"$f":"INDIRECT(M$5&\"!\"&CELL(\"address\",$C7))","v":2000},{"$f":"INDIRECT(N$5&\"!\"&CELL(\"address\",$C7))","v":2500},{"$f":"INDIRECT(O$5&\"!\"&CELL(\"address\",$C7))","v":4000},{"$f":"INDIRECT(P$5&\"!\"&CELL(\"address\",$C7))","v":3500},15500,null,null,null,null,null,null,null,null,null,"Mr. Smith"]
[null,"Mrs. Jackson",{"$f":"INDIRECT(K$5&\"!\"&CELL(\"address\",$C8))","v":9000},{"$f":"INDIRECT(L$5&\"!\"&CELL(\"address\",$C8))","v":8500},{"$f":"INDIRECT(M$5&\"!\"&CELL(\"address\",$C8))","v":8000},{"$f":"INDIRECT(N$5&\"!\"&CELL(\"address\",$C8))","v":10000},{"$f":"INDIRECT(O$5&\"!\"&CELL(\"address\",$C8))","v":10000},{"$f":"INDIRECT(P$5&\"!\"&CELL(\"address\",$C8))","v":9500},55000,null,null,null,null,null,null,null,null,null,"Ms. Lily"]
[null,"Mr. Howard",{"$f":"INDIRECT(K$5&\"!\"&CELL(\"address\",$C9))","v":5000},{"$f":"INDIRECT(L$5&\"!\"&CELL(\"address\",$C9))","v":4500},{"$f":"INDIRECT(M$5&\"!\"&CELL(\"address\",$C9))","v":3000},{"$f":"INDIRECT(N$5&\"!\"&CELL(\"address\",$C9))","v":6000},{"$f":"INDIRECT(O$5&\"!\"&CELL(\"address\",$C9))","v":8000},{"$f":"INDIRECT(P$5&\"!\"&CELL(\"address\",$C9))","v":5000},31500,null,null,null,null,null,null,null,null,null,"Mrs. Jackson"]
[null,"Mr. Musk",{"$f":"INDIRECT(K$5&\"!\"&CELL(\"address\",$C10))","v":6600},{"$f":"INDIRECT(L$5&\"!\"&CELL(\"address\",$C10))","v":15000},{"$f":"INDIRECT(M$5&\"!\"&CELL(\"address\",$C10))","v":20000},{"$f":"INDIRECT(N$5&\"!\"&CELL(\"address\",$C10))","v":30000},{"$f":"INDIRECT(O$5&\"!\"&CELL(\"address\",$C10))","v":35000},{"$f":"INDIRECT(P$5&\"!\"&CELL(\"address\",$C10))","v":32000},138600,null,null,null,null,null,null,null,null,null,"Mr. Howard"]
[null,"Mr. Gates",{"$f":"INDIRECT(K$5&\"!\"&CELL(\"address\",$C11))","v":8000},{"$f":"INDIRECT(L$5&\"!\"&CELL(\"address\",$C11))","v":8000},{"$f":"INDIRECT(M$5&\"!\"&CELL(\"address\",$C11))","v":10000},{"$f":"INDIRECT(N$5&\"!\"&CELL(\"address\",$C11))","v":18000},{"$f":"INDIRECT(O$5&\"!\"&CELL(\"address\",$C11))","v":25000},{"$f":"INDIRECT(P$5&\"!\"&CELL(\"address\",$C11))","v":20000},89000,null,null,null,null,null,null,null,null,null,"Mr. Musk"]
[null,"Mr. Lorry",{"$f":"INDIRECT(K$5&\"!\"&CELL(\"address\",$C12))","v":20000},{"$f":"INDIRECT(L$5&\"!\"&CELL(\"address\",$C12))","v":21000},{"$f":"INDIRECT(M$5&\"!\"&CELL(\"address\",$C12))","v":20500},{"$f":"INDIRECT(N$5&\"!\"&CELL(\"address\",$C12))","v":22000},{"$f":"INDIRECT(O$5&\"!\"&CELL(\"address\",$C12))","v":23000},{"$f":"INDIRECT(P$5&\"!\"&CELL(\"address\",$C12))","v":23000},129500,null,null,null,null,null,null,null,null,null,"Mr. Gates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. Lorry"]