{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet2","Sheet1","Sheet3","Sheet4"],"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":"Sheet2","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Sample Data Set"]
[]
[null,"Salesman","Jan","Feb","Mar","Apr","May ","Jun"]
[null,"Mike",1200,2465,3452,1321,2901,5674]
[null,"John",1120,3240,1253,5671,2800,9123]
[null,"Robert",4560,2789,2356,4738,9021,2351]
[null,"Jim",2425,1243,3723,1241,2593,2300]
[null,"Jill",2590,3403,3902,2671,3902,2450]
[null,"Daniel",1269,3452,1122,9201,2899,7890]

{"sheet":"Sheet1","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null," Utilizing SUMPRODUCT, MOD, and COLUMN Functions"]
[]
[null,"Salesman","Jan","Feb","Mar","Apr","May ","Jun",null,"Salesman","Total sales"]
[null,"Mike",1200,2465,3452,1321,2901,5674,null,"Mike",{"$f":"SUMPRODUCT(C5:H5*MOD(COLUMN(C5:H5)-COLUMN(C5)+1,2))","v":7553}]
[null,"John",1120,3240,1253,5671,2800,9123,null,"John",{"$f":"SUMPRODUCT(C6:H6*MOD(COLUMN(C6:H6)-COLUMN(C6)+1,2))","v":5173}]
[null,"Robert",4560,2789,2356,4738,9021,2351,null,"Robert",{"$f":"SUMPRODUCT(C7:H7*MOD(COLUMN(C7:H7)-COLUMN(C7)+1,2))","v":15937}]
[null,"Jim",2425,1243,3723,1241,2593,2300,null,"Jim",{"$f":"SUMPRODUCT(C8:H8*MOD(COLUMN(C8:H8)-COLUMN(C8)+1,2))","v":8741}]
[null,"Jill",2590,3403,3902,2671,3902,2450,null,"Jill",{"$f":"SUMPRODUCT(C9:H9*MOD(COLUMN(C9:H9)-COLUMN(C9)+1,2))","v":10394}]
[null,"Daniel",1269,3452,1122,9201,2899,7890,null,"Daniel",{"$f":"SUMPRODUCT(C10:H10*MOD(COLUMN(C10:H10)-COLUMN(C10)+1,2))","v":5290}]

{"sheet":"Sheet3","index":2,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"Incorporating SUM, COLUMN, and IF Functions"]
[]
[null,"Salesman","Jan","Feb","Mar","Apr","May ","Jun",null,"Salesman","Total Sales"]
[null,"Mike",1200,2465,3452,1321,2901,5674,null,"Mike",{"$f":"SUM(IF(MOD(COLUMN($C5:$H5),2)=0,$C5:$H5,0))","v":9460}]
[null,"John",1120,3240,1253,5671,2800,9123,null,"John",{"$f":"SUM(IF(MOD(COLUMN($C6:$H6),2)=0,$C6:$H6,0))","v":18034}]
[null,"Robert",4560,2789,2356,4738,9021,2351,null,"Robert",{"$f":"SUM(IF(MOD(COLUMN($C7:$H7),2)=0,$C7:$H7,0))","v":9878}]
[null,"Jim",2425,1243,3723,1241,2593,2300,null,"Jim",{"$f":"SUM(IF(MOD(COLUMN($C8:$H8),2)=0,$C8:$H8,0))","v":4784}]
[null,"Jill",2590,3403,3902,2671,3902,2450,null,"Jill",{"$f":"SUM(IF(MOD(COLUMN($C9:$H9),2)=0,$C9:$H9,0))","v":8524}]
[null,"Daniel",1269,3452,1122,9201,2899,7890,null,"Daniel",{"$f":"SUM(IF(MOD(COLUMN($C10:$H10),2)=0,$C10:$H10,0))","v":20543}]

{"sheet":"Sheet4","index":3,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Salesman","Jan","Feb","Mar","Apr","May ","Jun",null,"Salesman","Total Sales"]
[null,"Mike",1200,2465,3452,1321,2901,5674,null,"Mike",{"$f":"SkipColumns(C5:H5,2)","v":9460}]
[null,"John",1120,3240,1253,5671,2800,9123,null,"John",{"$f":"SkipColumns(C6:H6,2)","v":18034}]
[null,"Robert",4560,2789,2356,4738,9021,2351,null,"Robert",{"$f":"SkipColumns(C7:H7,2)","v":9878}]
[null,"Jim",2425,1243,3723,1241,2593,2300,null,"Jim",{"$f":"SkipColumns(C8:H8,2)","v":4784}]
[null,"Jill",2590,3403,3902,2671,3902,2450,null,"Jill",{"$f":"SkipColumns(C9:H9,2)","v":8524}]
[null,"Daniel",1269,3452,1122,9201,2899,7890,null,"Daniel",{"$f":"SkipColumns(C10:H10,2)","v":20543}]