{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Overview","SUMPRODUCT","FILTER","VBA","Odd or Even"],"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":"Overview","index":0,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"Overview of Dataset"]
[]
[null,"Product","January","February","March","April","May","June",null,"Interval","Total"]
[null,"Shirts",500,1000,500,800,1200,1200,null,2,{"$f":"SUMPRODUCT((MOD(COLUMN(C5:H5)-COLUMN(C5)+1,J5)=0)*1,C5:H5)","v":3000}]
[null,"Pants",600,900,1800,1800,1200,2000,null,3,{"$f":"SUMPRODUCT(--(MOD(COLUMN(C6:H6)-COLUMN(C6)+1,J6)=0),C6:H6)","v":3800}]
[null,"T-Shirts",500,200,500,800,1000,1200,null,2,{"$f":"SUMPRODUCT(--(MOD(COLUMN(C7:H7)-COLUMN(C7)+1,J7)=0)*C7:H7)","v":2200}]
[null,"Hoodies",1000,1200,900,700,550,300,null,3,{"$f":"SUMPRODUCT(--(MOD(COLUMN(C8:H8)-COLUMN(C8)+1,J8)=0)*C8:H8)","v":1200}]
[null,"Sweaters",2000,2000,1400,1000,400,100,null,4,1000]

{"sheet":"SUMPRODUCT","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"Combine SUMPRODUCT, MOD, and COLUMN Functions"]
[]
[null,"Product","January","February","March","April","May","June",null,"Interval","Total"]
[null,"Shirts",500,1000,500,800,1200,1200,null,2,{"$f":"SUMPRODUCT((MOD(COLUMN(C5:H5)-COLUMN(C5)+1,J5)=0)*1,C5:H5)","v":3000}]
[null,"Pants",600,900,1800,1800,1200,2000,null,3,{"$f":"SUMPRODUCT((MOD(COLUMN(C6:H6)-COLUMN(C6)+1,J6)=0)*1,C6:H6)","v":3800}]
[null,"T-Shirts",500,200,500,800,1000,1200,null,2,{"$f":"SUMPRODUCT((MOD(COLUMN(C7:H7)-COLUMN(C7)+1,J7)=0)*1,C7:H7)","v":2200}]
[null,"Hoodies",1000,1200,900,700,550,300,null,3,{"$f":"SUMPRODUCT((MOD(COLUMN(C8:H8)-COLUMN(C8)+1,J8)=0)*1,C8:H8)","v":1200}]
[null,"Sweaters",2000,2000,1400,1000,400,100,null,4,{"$f":"SUMPRODUCT((MOD(COLUMN(C9:H9)-COLUMN(C9)+1,J9)=0)*1,C9:H9)","v":1000}]

{"sheet":"FILTER","index":2,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"Merge SUM, FILTER, SEQUENCE and COLUMNS Functions"]
[]
[null,"Product","January","February","March","April","May","June",null,"Interval","Total"]
[null,"Shirts",500,1000,500,800,1200,1200,null,3,{"$f":"SUM(_xlfn._xlws.FILTER(C5:H5,MOD(_xlfn.SEQUENCE(1,COLUMNS(C5:H5)),J5)=0))","v":1700}]
[null,"Pants",600,900,1800,1800,1200,2000,null,2,{"$f":"SUM(_xlfn._xlws.FILTER(C6:H6,MOD(_xlfn.SEQUENCE(1,COLUMNS(C6:H6)),J6)=0))","v":4700}]
[null,"T-Shirts",500,200,500,800,1000,1200,null,3,{"$f":"SUM(_xlfn._xlws.FILTER(C7:H7,MOD(_xlfn.SEQUENCE(1,COLUMNS(C7:H7)),J7)=0))","v":1700}]
[null,"Hoodies",1000,1200,900,700,550,300,null,2,{"$f":"SUM(_xlfn._xlws.FILTER(C8:H8,MOD(_xlfn.SEQUENCE(1,COLUMNS(C8:H8)),J8)=0))","v":2200}]
[null,"Sweaters",2000,2000,1400,1000,400,100,null,4,{"$f":"SUM(_xlfn._xlws.FILTER(C9:H9,MOD(_xlfn.SEQUENCE(1,COLUMNS(C9:H9)),J9)=0))","v":1000}]

{"sheet":"VBA","index":3,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null," Using VBA Code to Sum Every nth Column"]
[]
[null,"Product","January","February","March","April","May","June",null,"Interval","Total"]
[null,"Shirts",500,1000,500,800,1200,1200,null,2,{"$f":"SUMINTERVAL(C5:H5,J5)","v":3000}]
[null,"Pants",600,900,1800,1800,1200,2000,null,3,{"$f":"SUMINTERVAL(C6:H6,J6)","v":3800}]
[null,"T-Shirts",500,200,500,800,1000,1200,null,2,{"$f":"SUMINTERVAL(C7:H7,J7)","v":2200}]
[null,"Hoodies",1000,1200,900,700,550,300,null,3,{"$f":"SUMINTERVAL(C8:H8,J8)","v":1200}]
[null,"Sweaters",2000,2000,1400,1000,400,100,null,4,{"$f":"SUMINTERVAL(C9:H9,J9)","v":1000}]

{"sheet":"Odd or Even","index":4,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"Summing by Even or Odd"]
[]
[null,"Product","January","February","March","April","May","June",null,"Odd","Even"]
[null,"Shirts",500,1000,500,800,1200,1200,null,{"$f":"SUMPRODUCT((MOD(COLUMN(C5:H5)-COLUMN(C5)+1,2)=1)*1,C5:H5)","v":2200},{"$f":"SUMPRODUCT((MOD(COLUMN(C5:H5)-COLUMN(C5)+1,2)=0)*1,C5:H5)","v":3000}]
[null,"Pants",600,900,1800,1800,1200,2000,null,{"$f":"SUMPRODUCT((MOD(COLUMN(C6:H6)-COLUMN(C6)+1,2)=1)*1,C6:H6)","v":3600},{"$f":"SUMPRODUCT((MOD(COLUMN(C6:H6)-COLUMN(C6)+1,2)=0)*1,C6:H6)","v":4700}]
[null,"T-Shirts",500,200,500,800,1000,1200,null,{"$f":"SUMPRODUCT((MOD(COLUMN(C7:H7)-COLUMN(C7)+1,2)=1)*1,C7:H7)","v":2000},{"$f":"SUMPRODUCT((MOD(COLUMN(C7:H7)-COLUMN(C7)+1,2)=0)*1,C7:H7)","v":2200}]
[null,"Hoodies",1000,1200,900,700,550,300,null,{"$f":"SUMPRODUCT((MOD(COLUMN(C8:H8)-COLUMN(C8)+1,2)=1)*1,C8:H8)","v":2450},{"$f":"SUMPRODUCT((MOD(COLUMN(C8:H8)-COLUMN(C8)+1,2)=0)*1,C8:H8)","v":2200}]
[null,"Sweaters",2000,2000,1400,1000,400,100,null,{"$f":"SUMPRODUCT((MOD(COLUMN(C9:H9)-COLUMN(C9)+1,2)=1)*1,C9:H9)","v":3800},{"$f":"SUMPRODUCT((MOD(COLUMN(C9:H9)-COLUMN(C9)+1,2)=0)*1,C9:H9)","v":3100}]