{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Formula","VBA Code","Even or Odd"],"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":"Formula","index":0,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sum Every nth Column"]
[]
["Formul","SUMPRODUCT((MOD(COLUMN(range)-COLUMN(range.firstCol)+1,interval)=0)*1,range)"]
[]
["Product Name","January","February","March","April","May","June",null,"Number of Interval","Total",null,null,"Formula We Have used"]
["Shirts",500,1000,500,800,1200,1200,null,2,{"$f":"SUMPRODUCT((MOD(COLUMN(B6:G6)-COLUMN(B6)+1,I6)=0)*1,B6:G6)","v":3000},null,null,"=SUMPRODUCT((MOD(COLUMN(B6:G6)-COLUMN(B6)+1,I6)=0)*1,B6:G6)"]
["Pants",600,900,1800,1800,1200,2000,null,3,{"$f":"SUMPRODUCT(--(MOD(COLUMN(B7:G7)-COLUMN(B7)+1,I7)=0),B7:G7)","v":3800},null,null,"=SUMPRODUCT(--(MOD(COLUMN(B7:G7)-COLUMN(B7)+1,I7)=0),B7:G7)"]
["T-Shirts",500,200,500,800,1000,1200,null,2,{"$f":"SUMPRODUCT(--(MOD(COLUMN(B8:G8)-COLUMN(B8)+1,I8)=0)*B8:G8)","v":2200},null,null,"=SUMPRODUCT(--(MOD(COLUMN(B8:G8)-COLUMN(B8)+1,I8)=0)*B8:G8)"]
["Hoodies",1000,1200,900,700,550,300,null,3,{"$f":"SUMPRODUCT(--(MOD(COLUMN(B9:G9)-COLUMN(B9)+1,I9)=0)*B9:G9)","v":1200}]
["Sweaters",2000,2000,1400,1000,400,0,null,4,1000]

{"sheet":"VBA Code","index":1,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Sum Every nth Column"]
[]
["Product Name","January","February","March","April","May","June",null,"Number of Interval","Total"]
["Shirts",500,1000,500,800,1200,1200,null,2,{"$f":"SUMINTERVAL(B4:G4,I4)","v":3000}]
["Pants",600,900,1800,1800,1200,2000,null,3,{"$f":"SUMINTERVAL(B5:G5,I5)","v":3800}]
["T-Shirts",500,200,500,800,1000,1200,null,4,800]
["Hoodies",1000,1200,900,700,550,300,null,3,1200]
["Sweaters",2000,2000,1400,1000,400,0,null,4,1000]

{"sheet":"Even or Odd","index":2,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Sum Every nth Column"]
[]
["Product Name","January","February","March","April","May","June",null,"Odd","Even"]
["Shirts",500,1000,500,800,1200,1200,null,{"$f":"SUMPRODUCT((MOD(COLUMN(B4:G4)-COLUMN(B4)+1,2)=1)*1,B4:G4)","v":2200},{"$f":"SUMPRODUCT((MOD(COLUMN(B4:G4)-COLUMN(B4)+1,2)=0)*1,B4:G4)","v":3000}]
["Pants",600,900,1800,1800,1200,2000,null,{"$f":"SUMPRODUCT((MOD(COLUMN(B5:G5)-COLUMN(B5)+1,2)=1)*1,B5:G5)","v":3600},{"$f":"SUMPRODUCT((MOD(COLUMN(B5:G5)-COLUMN(B5)+1,2)=0)*1,B5:G5)","v":4700}]
["T-Shirts",500,200,500,800,1000,1200,null,{"$f":"SUMPRODUCT((MOD(COLUMN(B6:G6)-COLUMN(B6)+1,2)=1)*1,B6:G6)","v":2000},{"$f":"SUMPRODUCT((MOD(COLUMN(B6:G6)-COLUMN(B6)+1,2)=0)*1,B6:G6)","v":2200}]
["Hoodies",1000,1200,900,700,550,300,null,{"$f":"SUMPRODUCT((MOD(COLUMN(B7:G7)-COLUMN(B7)+1,2)=1)*1,B7:G7)","v":2450},{"$f":"SUMPRODUCT((MOD(COLUMN(B7:G7)-COLUMN(B7)+1,2)=0)*1,B7:G7)","v":2200}]
["Sweaters",2000,2000,1400,1000,400,0,null,{"$f":"SUMPRODUCT((MOD(COLUMN(B8:G8)-COLUMN(B8)+1,2)=1)*1,B8:G8)","v":3800},{"$f":"SUMPRODUCT((MOD(COLUMN(B8:G8)-COLUMN(B8)+1,2)=0)*1,B8:G8)","v":3000}]