{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Data","Sumproduct day","IF DAY","SUMIFS WEEKDAY","SUMPRODUCT WEEKDAY","PIVOT","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Data","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Sum Values By Day"]
[]
[]
[]
["Sales Date","Day of the Week","Sales Amount"]
["2021-01-15","Friday",6727]
["2021-01-18","Monday",7893]
["2021-01-30","Saturday",9372]
["2021-02-15","Monday",7035]
["2021-02-28","Sunday",9466]
["2021-03-15","Monday",6966]
["2021-04-15","Thursday",5289]
["2021-04-24","Saturday",8228]
["2021-05-15","Saturday",5150]
["2021-05-17","Monday",5867]
["2021-06-15","Tuesday",9785]
["2021-06-23","Wednesday",8095]
["2021-07-15","Thursday",8017]

{"sheet":"Sumproduct day","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Sum Values By Day"]
[]
["Day",15]
[]
["Sales Date","Day of the Week","Sales Amount"]
["2021-01-15","Friday",6727,null,"Total sales on 15"]
["2021-01-18","Monday",7893,null,{"$f":"SUMPRODUCT((DAY(A6:A18)=B3)*C6:C18)","v":48969}]
["2021-01-30","Saturday",9372]
["2021-02-15","Monday",7035]
["2021-02-28","Sunday",9466]
["2021-03-15","Monday",6966]
["2021-04-15","Thursday",5289]
["2021-04-24","Saturday",8228]
["2021-05-15","Saturday",5150]
["2021-05-17","Monday",5867]
["2021-06-15","Tuesday",9785]
["2021-06-23","Wednesday",8095]
["2021-07-15","Thursday",8017]

{"sheet":"IF DAY","index":2,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Sum Values By Day"]
[]
["Day",15]
[]
["Sales Date","Day of the Week","Sales Amount"]
["2021-01-15","Friday",6727,null,"Total sales on 15"]
["2021-01-18","Monday",7893,null,{"$f":"SUM(IF(DAY(A6:A18)=B3,C6:C18,0),0)","v":48969}]
["2021-01-30","Saturday",9372]
["2021-02-15","Monday",7035]
["2021-02-28","Sunday",9466]
["2021-03-15","Monday",6966]
["2021-04-15","Thursday",5289]
["2021-04-24","Saturday",8228]
["2021-05-15","Saturday",5150]
["2021-05-17","Monday",5867]
["2021-06-15","Tuesday",9785]
["2021-06-23","Wednesday",8095]
["2021-07-15","Thursday",8017]

{"sheet":"SUMIFS WEEKDAY","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Sum Values By Day"]
[]
[]
[]
["Sales Date","Day of the Week","Sales Amount",null,"Day of the Week","Total Sales"]
["2021-01-15","Friday",6727,null,"Sunday",{"$f":"SUMIFS($C$6:$C$18,$B$6:$B$18,E6)","v":9466}]
["2021-01-18","Monday",7893,null,"Monday",{"$f":"SUMIFS($C$6:$C$18,$B$6:$B$18,E7)","v":27761}]
["2021-01-30","Saturday",9372,null,"Tuesday",9785]
["2021-02-15","Monday",7035,null,"Wednesday",8095]
["2021-02-28","Sunday",9466,null,"Thursday",13306]
["2021-03-15","Monday",6966,null,"Friday",6727]
["2021-04-15","Thursday",5289,null,"Saturday",22750]
["2021-04-24","Saturday",8228]
["2021-05-15","Saturday",5150]
["2021-05-17","Monday",5867]
["2021-06-15","Tuesday",9785]
["2021-06-23","Wednesday",8095]
["2021-07-15","Thursday",8017]

{"sheet":"SUMPRODUCT WEEKDAY","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Sum Values By Day"]
[]
[]
[]
["Sales Date","Day of the Week","Sales Amount",null,"Day of the Week Num","Day of the Week","Total Sales"]
["2021-01-15","Friday",6727,null,1,"Sunday",{"$f":"SUMPRODUCT(--(WEEKDAY($A$6:$A$18)=E6),$C$6:$C$18)","v":9466}]
["2021-01-18","Monday",7893,null,2,"Monday",{"$f":"SUMPRODUCT(--(WEEKDAY($A$6:$A$18)=E7),$C$6:$C$18)","v":27761}]
["2021-01-30","Saturday",9372,null,3,"Tuesday",{"$f":"SUMPRODUCT(--(WEEKDAY($A$6:$A$18)=E8),$C$6:$C$18)","v":9785}]
["2021-02-15","Monday",7035,null,4,"Wednesday",{"$f":"SUMPRODUCT(--(WEEKDAY($A$6:$A$18)=E9),$C$6:$C$18)","v":8095}]
["2021-02-28","Sunday",9466,null,5,"Thursday",{"$f":"SUMPRODUCT(--(WEEKDAY($A$6:$A$18)=E10),$C$6:$C$18)","v":13306}]
["2021-03-15","Monday",6966,null,6,"Friday",{"$f":"SUMPRODUCT(--(WEEKDAY($A$6:$A$18)=E11),$C$6:$C$18)","v":6727}]
["2021-04-15","Thursday",5289,null,7,"Saturday",{"$f":"SUMPRODUCT(--(WEEKDAY($A$6:$A$18)=E12),$C$6:$C$18)","v":22750}]
["2021-04-24","Saturday",8228]
["2021-05-15","Saturday",5150]
["2021-05-17","Monday",5867]
["2021-06-15","Tuesday",9785]
["2021-06-23","Wednesday",8095]
["2021-07-15","Thursday",8017]

{"sheet":"PIVOT","index":5,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Sum Values By Day"]
[]
[]
[]
["Sales Date","Day of the Week","Sales Amount",null,"Row Labels","Sum of Sales Amount"]
["2021-01-15","Friday",6727,null,"15-Jan",6727]
["2021-01-18","Monday",7893,null,"18-Jan",7893]
["2021-01-30","Saturday",9372,null,"30-Jan",9372]
["2021-02-15","Monday",7035,null,"15-Feb",7035]
["2021-02-28","Sunday",9466,null,"28-Feb",9466]
["2021-03-15","Monday",6966,null,"15-Mar",6966]
["2021-04-15","Thursday",5289,null,"15-Apr",5289]
["2021-04-24","Saturday",8228,null,"24-Apr",8228]
["2021-05-15","Saturday",5150,null,"15-May",5150]
["2021-05-17","Monday",5867,null,"17-May",5867]
["2021-06-15","Tuesday",9785,null,"15-Jun",9785]
["2021-06-23","Wednesday",8095,null,"23-Jun",8095]
["2021-07-15","Thursday",8017,null,"15-Jul",8017]
[null,null,null,null,"Grand Total",97890]

{"sheet":"VBA","index":6,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Sum Values By Day"]
[]
["Day",15]
[]
["Sales Date","Day of the Week","Sales Amount"]
["2021-01-15","Friday",6727,null,"Total sales on 15"]
["2021-01-18","Monday",7893,null,48969]
["2021-01-30","Saturday",9372]
["2021-02-15","Monday",7035]
["2021-02-28","Sunday",9466]
["2021-03-15","Monday",6966]
["2021-04-15","Thursday",5289]
["2021-04-24","Saturday",8228]
["2021-05-15","Saturday",5150]
["2021-05-17","Monday",5867]
["2021-06-15","Tuesday",9785]
["2021-06-23","Wednesday",8095]
["2021-07-15","Thursday",8017]