{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","SUMPRODUCT & DAY Functions","SUM, IF & DAY Functions","SUMIFS Function","SUMIFS with DATE Function","SUMPRODUCT & WEEKDAY Functions","SUMPRODUCT and TEXT Functions","Inserting Pivot Table","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":"Dataset","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Sales Date","Weekday","Sales Amount"]
[null,"2021-01-15","Friday",6727]
[null,"2021-01-18","Monday",7893]
[null,"2021-01-30","Saturday",9372]
[null,"2021-02-15","Monday",7035]
[null,"2021-02-28","Sunday",9466]
[null,"2021-03-15","Monday",6966]
[null,"2021-04-15","Thursday",5289]
[null,"2021-04-24","Saturday",8228]
[null,"2021-05-15","Saturday",5150]
[null,"2021-05-17","Monday",5867]

{"sheet":"SUMPRODUCT & DAY Functions","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Using SUMPRODUCT & DAY Functions",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Date","Weekday","Sales Amount",null,null,null,null,"Sales Date","Weekday","Sales Amount"]
[null,"2021-01-15","Friday",6727,null,null,null,null,"2021-01-15","Friday",6727]
[null,"2021-01-18","Monday",7893,null,null,null,null,"2021-01-18","Monday",7893]
[null,"2021-01-30","Saturday",9372,null,null,null,null,"2021-01-30","Saturday",9372]
[null,"2021-02-15","Monday",7035,null,null,null,null,"2021-02-15","Monday",7035]
[null,"2021-02-28","Sunday",9466,null,null,null,null,"2021-02-28","Sunday",9466]
[null,"2021-03-15","Monday",6966,null,null,null,null,"2021-03-15","Monday",6966]
[null,"2021-04-15","Thursday",5289,null,null,null,null,"2021-04-15","Thursday",5289]
[null,"2021-04-24","Saturday",8228,null,null,null,null,"2021-04-24","Saturday",8228]
[null,"2021-05-15","Saturday",5150,null,null,null,null,"2021-05-15","Saturday",5150]
[null,"2021-05-17","Monday",5867,null,null,null,null,"2021-05-17","Monday",5867]
[]
[null,"Day",15,null,null,null,null,null,"Day",15]
[null,"Total Sales on 15",{"$f":"SUMPRODUCT((DAY(B5:B14)=C16)*D5:D14)","v":31167},null,null,null,null,null,"Total Sales on 15"]

{"sheet":"SUM, IF & DAY Functions","index":2,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Combining SUM, IF & DAY Functions",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Date","Weekday","Sales Amount",null,null,null,null,null,"Sales Date","Weekday","Sales Amount"]
[null,"2021-01-15","Friday",6727,null,null,null,null,null,"2021-01-15","Friday",6727]
[null,"2021-01-18","Monday",7893,null,null,null,null,null,"2021-01-18","Monday",7893]
[null,"2021-01-30","Saturday",9372,null,null,null,null,null,"2021-01-30","Saturday",9372]
[null,"2021-02-15","Monday",7035,null,null,null,null,null,"2021-02-15","Monday",7035]
[null,"2021-02-28","Sunday",9466,null,null,null,null,null,"2021-02-28","Sunday",9466]
[null,"2021-03-15","Monday",6966,null,null,null,null,null,"2021-03-15","Monday",6966]
[null,"2021-04-15","Thursday",5289,null,null,null,null,null,"2021-04-15","Thursday",5289]
[null,"2021-04-24","Saturday",8228,null,null,null,null,null,"2021-04-24","Saturday",8228]
[null,"2021-05-15","Saturday",5150,null,null,null,null,null,"2021-05-15","Saturday",5150]
[null,"2021-05-17","Monday",5867,null,null,null,null,null,"2021-05-17","Monday",5867]
[]
[null,"Day",15,null,null,null,null,null,null,"Day",15]
[null,"Total Sales on 15",{"$f":"SUM(IF(DAY(B5:B14)=C16,D5:D14,0),0)","v":31167},null,null,null,null,null,null,"Total Sales on 15"]

{"sheet":"SUMIFS Function","index":3,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Applying SUMIFS Function",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Date","Weekday","Sales Amount",null,"Weekday","Total Sales",null,null,null,null,null,"Sales Date","Weekday","Sales Amount",null,"Weekday","Total Sales"]
[null,"2021-01-15","Friday",6727,null,"Sunday",{"$f":"SUMIFS($D$5:$D$14,$C$5:$C$14,F5)","v":9466},null,null,null,null,null,"2021-01-15","Friday",6727,null,"Sunday"]
[null,"2021-01-18","Monday",7893,null,"Monday",{"$f":"SUMIFS($D$5:$D$14,$C$5:$C$14,F6)","v":27761},null,null,null,null,null,"2021-01-18","Monday",7893,null,"Monday"]
[null,"2021-01-30","Saturday",9372,null,"Tuesday",0,null,null,null,null,null,"2021-01-30","Saturday",9372,null,"Tuesday"]
[null,"2021-02-15","Monday",7035,null,"Wednesday",0,null,null,null,null,null,"2021-02-15","Monday",7035,null,"Wednesday"]
[null,"2021-02-28","Sunday",9466,null,"Thursday",5289,null,null,null,null,null,"2021-02-28","Sunday",9466,null,"Thursday"]
[null,"2021-03-15","Monday",6966,null,"Friday",6727,null,null,null,null,null,"2021-03-15","Monday",6966,null,"Friday"]
[null,"2021-04-15","Thursday",5289,null,"Saturday",22750,null,null,null,null,null,"2021-04-15","Thursday",5289,null,"Saturday"]
[null,"2021-04-24","Saturday",8228,null,null,null,null,null,null,null,null,"2021-04-24","Saturday",8228]
[null,"2021-05-15","Saturday",5150,null,null,null,null,null,null,null,null,"2021-05-15","Saturday",5150]
[null,"2021-05-17","Monday",5867,null,null,null,null,null,null,null,null,"2021-05-17","Monday",5867]

{"sheet":"SUMIFS with DATE Function","index":4,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using SUMIFS and DATE Functions",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Date","Weekday","Sales Amount",null,null,null,null,null,"Sales Date","Weekday","Sales Amount"]
[null,"2021-01-15","Friday",6727,null,null,null,null,null,"2021-01-15","Friday",6727]
[null,"2021-01-18","Monday",7893,null,null,null,null,null,"2021-01-18","Monday",7893]
[null,"2021-01-30","Saturday",9372,null,null,null,null,null,"2021-01-30","Saturday",9372]
[null,"2021-02-01","Monday",7035,null,null,null,null,null,"2021-02-01","Monday",7035]
[null,"2021-02-28","Sunday",9466,null,null,null,null,null,"2021-02-28","Sunday",9466]
[null,"2021-03-15","Monday",6966,null,null,null,null,null,"2021-03-15","Monday",6966]
[null,"2021-04-15","Thursday",5289,null,null,null,null,null,"2021-04-15","Thursday",5289]
[null,"2021-04-24","Saturday",8228,null,null,null,null,null,"2021-04-24","Saturday",8228]
[null,"2021-05-15","Saturday",5150,null,null,null,null,null,"2021-05-15","Saturday",5150]
[null,"2021-05-17","Monday",5867,null,null,null,null,null,"2021-05-17","Monday",5867]
[]
[null,"Total Sales from February on Monday",{"$f":"SUMIFS(D5:D14,B5:B14,\">=\"&DATE(2021,2,1),C5:C14,\"Monday\")","v":19868},null,null,null,null,null,null,"Total Sales from February on Monday"]

{"sheet":"SUMPRODUCT & WEEKDAY Functions","index":5,"n_rows":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,12,1,18]]}
[]
[null,"Using SUMPRODUCT & WEEKDAY Functions",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Date","Weekday","Sales Amount",null,"Serial No. of Weekday","Weekday","Total Sales",null,null,null,null,"Sales Date","Weekday","Sales Amount",null,"Serial No. of Weekday","Weekday","Total Sales"]
[null,"2021-01-15","Friday",6727,null,1,"Sunday",{"$f":"SUMPRODUCT(--(WEEKDAY($B$5:$B$14)=F5),$D$5:$D$14)","v":9466},null,null,null,null,"2021-01-15","Friday",6727,null,1,"Sunday"]
[null,"2021-01-18","Monday",7893,null,2,"Monday",{"$f":"SUMPRODUCT(--(WEEKDAY($B$5:$B$14)=F6),$D$5:$D$14)","v":27761},null,null,null,null,"2021-01-18","Monday",7893,null,2,"Monday"]
[null,"2021-01-30","Saturday",9372,null,3,"Tuesday",{"$f":"SUMPRODUCT(--(WEEKDAY($B$5:$B$14)=F7),$D$5:$D$14)","v":0},null,null,null,null,"2021-01-30","Saturday",9372,null,3,"Tuesday"]
[null,"2021-02-15","Monday",7035,null,4,"Wednesday",{"$f":"SUMPRODUCT(--(WEEKDAY($B$5:$B$14)=F8),$D$5:$D$14)","v":0},null,null,null,null,"2021-02-15","Monday",7035,null,4,"Wednesday"]
[null,"2021-02-28","Sunday",9466,null,5,"Thursday",{"$f":"SUMPRODUCT(--(WEEKDAY($B$5:$B$14)=F9),$D$5:$D$14)","v":5289},null,null,null,null,"2021-02-28","Sunday",9466,null,5,"Thursday"]
[null,"2021-03-15","Monday",6966,null,6,"Friday",{"$f":"SUMPRODUCT(--(WEEKDAY($B$5:$B$14)=F10),$D$5:$D$14)","v":6727},null,null,null,null,"2021-03-15","Monday",6966,null,6,"Friday"]
[null,"2021-04-15","Thursday",5289,null,7,"Saturday",{"$f":"SUMPRODUCT(--(WEEKDAY($B$5:$B$14)=F11),$D$5:$D$14)","v":22750},null,null,null,null,"2021-04-15","Thursday",5289,null,7,"Saturday"]
[null,"2021-04-24","Saturday",8228,null,null,null,null,null,null,null,null,"2021-04-24","Saturday",8228]
[null,"2021-05-15","Saturday",5150,null,null,null,null,null,null,null,null,"2021-05-15","Saturday",5150]
[null,"2021-05-17","Monday",5867,null,null,null,null,null,null,null,null,"2021-05-17","Monday",5867]

{"sheet":"SUMPRODUCT and TEXT Functions","index":6,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Utilizing SUMPRODUCT and TEXT Functions",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Date","Weekday","Sales Amount",null,"Weekday","Total Sales",null,null,null,null,null,"Sales Date","Weekday","Sales Amount",null,"Weekday","Total Sales"]
[null,"2021-01-15","Friday",6727,null,"Sunday",{"$f":"SUMPRODUCT(--(TEXT($C$5:$C$14,\"ddd\")=F5),$D$5:$D$14)","v":9466},null,null,null,null,null,"2021-01-15","Friday",6727,null,"Sunday"]
[null,"2021-01-18","Monday",7893,null,"Monday",{"$f":"SUMPRODUCT(--(TEXT($C$5:$C$14,\"ddd\")=F6),$D$5:$D$14)","v":27761},null,null,null,null,null,"2021-01-18","Monday",7893,null,"Monday"]
[null,"2021-01-30","Saturday",9372,null,"Tuesday",{"$f":"SUMPRODUCT(--(TEXT($C$5:$C$14,\"ddd\")=F7),$D$5:$D$14)","v":0},null,null,null,null,null,"2021-01-30","Saturday",9372,null,"Tuesday"]
[null,"2021-02-15","Monday",7035,null,"Wednesday",{"$f":"SUMPRODUCT(--(TEXT($C$5:$C$14,\"ddd\")=F8),$D$5:$D$14)","v":0},null,null,null,null,null,"2021-02-15","Monday",7035,null,"Wednesday"]
[null,"2021-02-28","Sunday",9466,null,"Thursday",{"$f":"SUMPRODUCT(--(TEXT($C$5:$C$14,\"ddd\")=F9),$D$5:$D$14)","v":5289},null,null,null,null,null,"2021-02-28","Sunday",9466,null,"Thursday"]
[null,"2021-03-15","Monday",6966,null,"Friday",{"$f":"SUMPRODUCT(--(TEXT($C$5:$C$14,\"ddd\")=F10),$D$5:$D$14)","v":6727},null,null,null,null,null,"2021-03-15","Monday",6966,null,"Friday"]
[null,"2021-04-15","Thursday",5289,null,"Saturday",{"$f":"SUMPRODUCT(--(TEXT($C$5:$C$14,\"ddd\")=F11),$D$5:$D$14)","v":22750},null,null,null,null,null,"2021-04-15","Thursday",5289,null,"Saturday"]
[null,"2021-04-24","Saturday",8228,null,null,null,null,null,null,null,null,"2021-04-24","Saturday",8228]
[null,"2021-05-15","Saturday",5150,null,null,null,null,null,null,null,null,"2021-05-15","Saturday",5150]
[null,"2021-05-17","Monday",5867,null,null,null,null,null,null,null,null,"2021-05-17","Monday",5867]

{"sheet":"Inserting Pivot Table","index":7,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Inserting Pivot Table",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Date","Weekday","Sales Amount",null,null,null,null,null,null,"Sales Date","Weekday","Sales Amount"]
[null,"2021-01-15","Friday",6727,null,null,null,null,null,null,"2021-01-15","Friday",6727]
[null,"2021-01-18","Monday",7893,null,null,null,null,null,null,"2021-01-18","Monday",7893]
[null,"2021-01-30","Saturday",9372,null,null,null,null,null,null,"2021-01-30","Saturday",9372]
[null,"2021-02-15","Monday",7035,null,null,null,null,null,null,"2021-02-15","Monday",7035]
[null,"2021-02-28","Sunday",9466,null,null,null,null,null,null,"2021-02-28","Sunday",9466]
[null,"2021-03-15","Monday",6966,null,null,null,null,null,null,"2021-03-15","Monday",6966]
[null,"2021-04-15","Thursday",5289,null,null,null,null,null,null,"2021-04-15","Thursday",5289]
[null,"2021-04-24","Saturday",8228,null,null,null,null,null,null,"2021-04-24","Saturday",8228]
[null,"2021-05-15","Saturday",5150,null,null,null,null,null,null,"2021-05-15","Saturday",5150]
[null,"2021-05-17","Monday",5867,null,null,null,null,null,null,"2021-05-17","Monday",5867]
[]
[null,"Row Labels","Sum of Sales Amount"]
[null,"15-Jan",6727]
[null,"18-Jan",7893]
[null,"30-Jan",9372]
[null,"15-Feb",7035]
[null,"28-Feb",9466]
[null,"15-Mar",6966]
[null,"15-Apr",5289]
[null,"24-Apr",8228]
[null,"15-May",5150]
[null,"17-May",5867]
[null,"Grand Total",71993]

{"sheet":"VBA","index":8,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Using VBA",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Date","Weekday","Sales Amount",null,null,null,null,null,null,"Sales Date","Weekday","Sales Amount"]
[null,"2021-01-15","Friday",6727,null,null,null,null,null,null,"2021-01-15","Friday",6727]
[null,"2021-01-18","Monday",7893,null,null,null,null,null,null,"2021-01-18","Monday",7893]
[null,"2021-01-30","Saturday",9372,null,null,null,null,null,null,"2021-01-30","Saturday",9372]
[null,"2021-02-15","Monday",7035,null,null,null,null,null,null,"2021-02-15","Monday",7035]
[null,"2021-02-28","Sunday",9466,null,null,null,null,null,null,"2021-02-28","Sunday",9466]
[null,"2021-03-15","Monday",6966,null,null,null,null,null,null,"2021-03-15","Monday",6966]
[null,"2021-04-15","Thursday",5289,null,null,null,null,null,null,"2021-04-15","Thursday",5289]
[null,"2021-04-24","Saturday",8228,null,null,null,null,null,null,"2021-04-24","Saturday",8228]
[null,"2021-05-15","Saturday",5150,null,null,null,null,null,null,"2021-05-15","Saturday",5150]
[null,"2021-05-17","Monday",5867,null,null,null,null,null,null,"2021-05-17","Monday",5867]
[]
[null,"Day",15,null,null,null,null,null,null,null,"Day",15]
[null,"Total Sales on 15",31167,null,null,null,null,null,null,null,"Total Sales on 15"]