{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","SUMIF","SUBTOTAL & Filter","Table","Get.Cell","Get.Cell (2)","VBA code for Color Index","Using VBA Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Summing Values If Cell Color is Green"]
[]
[null,"Month","Sales"]
[null,"January",1200]
[null,"February",1000]
[null,"March",1400]
[null,"April",1500]
[null,"May",1900]
[null,"June",2000]
[null,"July",2100]

{"sheet":"SUMIF","index":1,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2],[1,8,1,10],[11,8,11,9]]}
[]
[null,"Applying SUMIF Function",null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Month","Sales","Color",null,null,null,null,"Month","Sales","Color"]
[null,"January",1200,"Green",null,null,null,null,"January",1200,"Green"]
[null,"February",1000,"White",null,null,null,null,"February",1000,"White"]
[null,"March",1400,"Green",null,null,null,null,"March",1400,"Green"]
[null,"April",1500,"White",null,null,null,null,"April",1500,"White"]
[null,"May",1900,"White",null,null,null,null,"May",1900,"White"]
[null,"June",2000,"Green",null,null,null,null,"June",2000,"Green"]
[null,"July",2100,"White",null,null,null,null,"July",2100,"White"]
[null,"Sum of the Green Colored Sales",null,{"$f":"SUMIF(D5:D11,\"Green\",C5:C11)","v":4600},null,null,null,null,"Sum of the Green Colored Sales"]

{"sheet":"SUBTOTAL & Filter","index":2,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,2],[19,1,19,2]]}
[]
[null,"Combining SUBTOTAL Function & Filter Feature"]
[]
[null,"Month","Sales"]
[null,"January",1200]
[null,"February",1000]
[null,"March",1400]
[null,"April",1500]
[null,"May",1900]
[null,"June",2000]
[null,"July",2100]
[null,"Sum of the Green Colored Sales",{"$f":"SUBTOTAL(9,C5:C11)","v":4600}]
[]
[]
[]
[]
[]
[]
[]
[null,">>> Do It Yourself <<<"]
[]
[null,"Month","Sales"]
[null,"January",1200]
[null,"February",1000]
[null,"March",1400]
[null,"April",1500]
[null,"May",1900]
[null,"June",2000]
[null,"July",2100]
[null,"Sum of the Green Colored Sales"]

{"sheet":"Table","index":3,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,2],[19,1,19,2]]}
[]
[null,"Creating Table"]
[]
[null,"Month","Sales"]
[null,"January",1200]
[null,"February",1000]
[null,"March",1400]
[null,"April",1500]
[null,"May",1900]
[null,"June",2000]
[null,"July",2100]
[null,"Total",{"$f":"SUBTOTAL(109,Table1[Sales])","v":4600}]
[]
[]
[]
[]
[]
[]
[]
[null,">>> Do It Yourself <<<"]
[]
[null,"Month","Sales"]
[null,"January",1200]
[null,"February",1000]
[null,"March",1400]
[null,"April",1500]
[null,"May",1900]
[null,"June",2000]
[null,"July",2100]

{"sheet":"Get.Cell","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[11,1,11,2],[1,9,1,11],[11,9,11,10]]}
[]
[null,"Using GET.CELL Function",null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Month","Sales","Color Code",null,null,null,null,null,"Month","Sales","Color Code"]
[null,"January",1200,{"$f":"Color_Code","v":4},null,null,null,null,null,"January",1200]
[null,"February",1000,{"$f":"Color_Code","v":0},null,null,null,null,null,"February",1000]
[null,"March",1400,{"$f":"Color_Code","v":4},null,null,null,null,null,"March",1400]
[null,"April",1500,{"$f":"Color_Code","v":0},null,null,null,null,null,"April",1500]
[null,"May",1900,{"$f":"Color_Code","v":0},null,null,null,null,null,"May",1900]
[null,"June",2000,{"$f":"Color_Code","v":4},null,null,null,null,null,"June",2000]
[null,"July",2100,{"$f":"Color_Code","v":0},null,null,null,null,null,"July",2100]
[null,"Sum of the Green Colored Cells",null,{"$f":"SUMIF(D5:D11,4,C5:C11)","v":4600},null,null,null,null,null,"Sum of the Green Colored Cells"]

{"sheet":"Get.Cell (2)","index":5,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11],[11,1,11,2],[11,9,11,10]]}
[]
[null,"Using GET.CELL Function",null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Month","Sales","Color Code",null,null,null,null,null,"Month","Sales","Color Code"]
[null,"January",1200,{"$f":"Color_Code","v":4},null,null,null,null,null,"January",1200]
[null,"February",1000,{"$f":"Color_Code","v":0},null,null,null,null,null,"February",1000]
[null,"March",1400,{"$f":"Color_Code","v":4},null,null,null,null,null,"March",1400]
[null,"April",1500,{"$f":"Color_Code","v":0},null,null,null,null,null,"April",1500]
[null,"May",1900,{"$f":"Color_Code","v":0},null,null,null,null,null,"May",1900]
[null,"June",2000,{"$f":"Color_Code","v":4},null,null,null,null,null,"June",2000]
[null,"July",2100,{"$f":"Color_Code","v":0},null,null,null,null,null,"July",2100]
[null,"Sum of the Green Colored Cells",null,null,null,null,null,null,null,"Sum of the Green Colored Cells"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"VBA code for Color Index","index":6,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10],[11,1,11,2],[11,8,11,9]]}
[]
[null,"Applying VBA to Get Color Code",null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Month","Sales","Index for Color",null,null,null,null,"Month","Sales","Color Index"]
[null,"January",1200,{"$f":"index_for_color(C5)","v":4},null,null,null,null,"January",1200]
[null,"February",1000,{"$f":"index_for_color(C6)","v":-4142},null,null,null,null,"February",1000]
[null,"March",1400,{"$f":"index_for_color(C7)","v":4},null,null,null,null,"March",1400]
[null,"April",1500,{"$f":"index_for_color(C8)","v":-4142},null,null,null,null,"April",1500]
[null,"May",1900,{"$f":"index_for_color(C9)","v":-4142},null,null,null,null,"May",1900]
[null,"June",2000,{"$f":"index_for_color(C10)","v":4},null,null,null,null,"June",2000]
[null,"July",2100,{"$f":"index_for_color(C11)","v":-4142},null,null,null,null,"July",2100]
[null,"Sum of the Green Colored Sales",null,{"$f":"SUMIF(D5:D11,4,C5:C11)","v":4600},null,null,null,null,"Sum of the Green Colored Sales"]

{"sheet":"Using VBA Code","index":7,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using VBA Code to Get Summed up Value",null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Month","Sales",null,null,null,null,null,"Month","Sales"]
[null,"January",1200,null,null,null,null,null,"January",1200]
[null,"February",1000,null,null,null,null,null,"February",1000]
[null,"March",1400,null,null,null,null,null,"March",1400]
[null,"April",1500,null,null,null,null,null,"April",1500]
[null,"May",1900,null,null,null,null,null,"May",1900]
[null,"June",2000,null,null,null,null,null,"June",2000]
[null,"July",2100,null,null,null,null,null,"July",2100]
[]
[null,"Sum  by Green Color",{"$f":"Sum_by_Green_Color(C5,C5:C11)","v":4600},null,null,null,null,null,"Sum  by Green Color"]