{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","SUMIFS","EOMONTH","DATE","TODAY","TODAY (2)","TODAY (3)","SUM & IF","SUMPRODUCT","VBA","Practice"],"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":"Dataset","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"\"XYZ\" Company"]
[]
[null,"Product","Delivery Date","Region","Sales"]
[null,"Apple","2022-01-09","East",1402]
[null,"Apricots","2022-01-12","East",5935]
[null,"Banana","2022-01-27","South",6835]
[null,"Blackberries","2022-02-25","East",7871]
[null,"Cabbage","2022-02-27","North",9496]
[null,"Beet Greens","2022-03-30","North",1734]
[null,"Broccoli","2022-03-15","South",4662]
[null,"Eggplant","2022-03-28","North",4500]

{"sheet":"SUMIFS","index":1,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using SUMIFS Function"]
[]
[null,"Product","Delivery Date","Region","Sales"]
[null,"Apple","2022-01-09","East",1402]
[null,"Apricots","2022-01-12","East",5935]
[null,"Banana","2022-01-27","South",6835]
[null,"Blackberries","2022-02-25","East",7871]
[null,"Cabbage","2022-02-27","North",9496]
[null,"Beet Greens","2022-03-30","North",1734]
[null,"Broccoli","2022-03-15","South",4662]
[null,"Eggplant","2022-03-28","North",4500]
[]
[null,"Start Date","End Date","Region","Sum of Sales"]
[null,"2022-01-10","2022-03-20","East",{"$f":"SUMIFS(E4:E11,C4:C11,\">=\"&B14,C4:C11,\"<=\"&C14,D4:D11,\"East\")","v":13806}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"EOMONTH","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"SUMIFS with EOMONTH Function"]
[]
[null,"Product","Delivery Date","Region","Sales"]
[null,"Apple","2022-01-09","East",1402]
[null,"Apricots","2022-01-12","East",5935]
[null,"Banana","2022-01-27","South",6835]
[null,"Blackberries","2022-02-25","East",7871]
[null,"Cabbage","2022-02-27","North",9496]
[null,"Beet Greens","2022-03-30","North",1734]
[null,"Broccoli","2022-03-15","South",4662]
[null,"Eggplant","2022-03-28","North",4500]
[]
[null,"Start Date","Region","Sum of Sales"]
[null,"2022-01-01","South",{"$f":"SUMIFS(E4:E11,C4:C11,\">=\"&B14,C4:C11,\"<=\"&EOMONTH(B14,0),D4:D11,C14)","v":6835}]

{"sheet":"DATE","index":3,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using SUMIFS and DATE Function"]
[]
[null,"Product","Delivery Date","Region","Sales"]
[null,"Apple","2022-01-09","East",1402]
[null,"Apricots","2022-01-12","East",5935]
[null,"Banana","2022-01-27","South",6835]
[null,"Blackberries","2022-02-25","East",7871]
[null,"Cabbage","2022-02-27","North",9496]
[null,"Beet Greens","2022-03-30","North",1734]
[null,"Broccoli","2022-03-15","South",4662]
[null,"Eggplant","2022-03-28","North",4500]
[]
[null,"Start Date","End Date","Region","Sum of Sales"]
[null,"2022-01-10","2022-03-20","North",{"$f":"SUMIFS(E4:E11,C4:C11,\">=\"&DATE(2022,1,10),C4:C11,\"<=\"&DATE(2022,3,20),D4:D11,D14)","v":9496}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"TODAY","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"SUMIFS with TODAY Function"]
[]
[null,"Product","Delivery Date","Region","Sales"]
[null,"Apple","2022-01-09","East",1402]
[null,"Apricots","2022-01-12","East",5935]
[null,"Banana","2022-01-27","South",6835]
[null,"Blackberries","2022-02-25","East",7871]
[null,"Cabbage","2022-02-27","North",9496]
[null,"Beet Greens","2022-03-30","North",1734]
[null,"Broccoli","2022-03-15","South",4662]
[null,"Eggplant","2022-03-28","North",4500]
[]
[null,"Start Date","Region","Sum of Sales"]
[null,"2022-01-01","East",{"$f":"SUMIFS(E4:E11,C4:C11,\">=\"&B14,C4:C11,\"<=\"&TODAY(),D4:D11,C14)","v":15208}]

{"sheet":"TODAY (2)","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"SUMIFS with TODAY Function"]
[]
[null,"Product","Delivery Date","Region","Sales"]
[null,"Apple","2022-01-09","East",1402]
[null,"Apricots","2022-01-12","East",5935]
[null,"Banana","2022-01-27","South",6835]
[null,"Blackberries","2022-02-25","East",7871]
[null,"Cabbage","2022-02-27","North",9496]
[null,"Beet Greens","2022-03-30","North",1734]
[null,"Broccoli","2022-03-15","South",4662]
[null,"Eggplant","2022-03-28","North",4500]
[]
[null,"Start Date","Region","Sum of Sales"]
[null,"2022-01-01","East",{"$f":"SUMIFS(E4:E11,C4:C11,\">=\"&B14,C4:C11,\"<=\"&TODAY()-10,D4:D11,C14)","v":15208}]

{"sheet":"TODAY (3)","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"SUMIFS with TODAY Function"]
[]
[null,"Product","Delivery Date","Region","Sales"]
[null,"Apple","2022-01-09","East",1402]
[null,"Apricots","2022-01-12","East",5935]
[null,"Banana","2022-01-27","South",6835]
[null,"Blackberries","2022-02-25","East",7871]
[null,"Cabbage","2022-02-27","North",9496]
[null,"Beet Greens","2022-03-30","North",1734]
[null,"Broccoli","2022-03-15","South",4662]
[null,"Eggplant","2022-03-28","North",4500]
[]
[null,"Start Date","Region","Sum of Sales"]
[null,"2022-01-01","East",{"$f":"SUMIFS(E4:E11,C4:C11,\">=\"&B14,C4:C11,\"<=\"&TODAY()+10,D4:D11,C14)","v":15208}]

{"sheet":"SUM & IF","index":7,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using SUM and IF Function"]
[]
[null,"Product","Delivery Date","Region","Sales"]
[null,"Apple","2022-01-09","East",1402]
[null,"Apricots","2022-01-12","East",5935]
[null,"Banana","2022-01-27","South",6835]
[null,"Blackberries","2022-02-25","East",7871]
[null,"Cabbage","2022-02-27","North",9496]
[null,"Beet Greens","2022-03-30","North",1734]
[null,"Broccoli","2022-03-15","South",4662]
[null,"Eggplant","2022-03-28","North",4500]
[]
[null,"Start Date","End Date","Region","Sum of Sales"]
[null,"2022-01-10","2022-03-20","East",{"$f":"SUM(IF((C4:C11)>=B14,IF((C4:C11)<=C14,IF(D4:D11=D14,E4:E11))))","v":13806}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"SUMPRODUCT","index":8,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using SUMPRODUCT Function"]
[]
[null,"Product","Delivery Date","Region","Sales"]
[null,"Apple","2022-01-09","East",1402]
[null,"Apricots","2022-01-12","East",5935]
[null,"Banana","2022-01-27","South",6835]
[null,"Blackberries","2022-02-25","East",7871]
[null,"Cabbage","2022-02-27","North",9496]
[null,"Beet Greens","2022-03-30","North",1734]
[null,"Broccoli","2022-03-15","South",4662]
[null,"Eggplant","2022-03-28","North",4500]
[]
[null,"Start Date","End Date","Region","Sum of Sales"]
[null,"2022-01-01","2022-01-31","East",{"$f":"SUMPRODUCT((MONTH(C4:C11)=1)*(YEAR(C4:C11)=2022)*(D4:D11=D14)*E4:E11)","v":7337}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"VBA","index":9,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using VBA Code"]
[]
[null,"Product","Delivery Date","Region","Sales"]
[null,"Apple","2022-01-09","East",1402]
[null,"Apricots","2022-01-12","East",5935]
[null,"Banana","2022-01-27","South",6835]
[null,"Blackberries","2022-02-25","East",7871]
[null,"Cabbage","2022-02-27","North",9496]
[null,"Beet Greens","2022-03-30","North",1734]
[null,"Broccoli","2022-03-15","South",4662]
[null,"Eggplant","2022-03-28","North",4500]
[]
[null,"Start Date","End Date","Region","Sum of Sales"]
[null,"2022-01-10","2022-03-20","East",13806]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Practice","index":10,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Practice"]
[]
[null,"Product","Delivery Date","Region","Sales"]
[null,"Apple","2022-01-09","East",1402]
[null,"Apricots","2022-01-12","East",5935]
[null,"Banana","2022-01-27","South",6835]
[null,"Blackberries","2022-02-25","East",7871]
[null,"Cabbage","2022-02-27","North",9496]
[null,"Beet Greens","2022-03-30","North",1734]
[null,"Broccoli","2022-03-15","South",4662]
[null,"Eggplant","2022-03-28","North",4500]