{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","SUMIF_Color_Code","SUMIF_Color_Name","VBA","UserForm","Filter_SUBTOTAL","SUM_SUMIFS_Functions","COUNTIF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sales of Products"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","Asia",4678]
[null,"Mango","Africa",6789]
[null,"Banana","Europe",2656]
[null,"Apple","Africa",4800]
[null,"Banana","Asia",2589]
[null,"Mango","Asia",6545]
[null,"Banana","Africa",2434]
[null,"Apple","Europe",4766]
[null,"Mango","Europe",6600]

{"sheet":"SUMIF_Color_Code","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[13,1,13,3],[1,9,1,12],[13,9,13,11]]}
[]
[null,"SUMIF Based on Cell Color Code",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product","Region","Sales","Color Code",null,null,null,null,"Product","Region","Sales","Color Code"]
[null,"Apple","Asia",4678,{"$f":"Cell_Color_Code","v":6},null,null,null,null,"Apple","Asia",4678]
[null,"Mango","Africa",6789,{"$f":"Cell_Color_Code","v":10},null,null,null,null,"Mango","Africa",6789]
[null,"Banana","Europe",2656,{"$f":"Cell_Color_Code","v":0},null,null,null,null,"Banana","Europe",2656]
[null,"Apple","Africa",4800,{"$f":"Cell_Color_Code","v":6},null,null,null,null,"Apple","Africa",4800]
[null,"Banana","Asia",2589,{"$f":"Cell_Color_Code","v":0},null,null,null,null,"Banana","Asia",2589]
[null,"Mango","Asia",6545,{"$f":"Cell_Color_Code","v":10},null,null,null,null,"Mango","Asia",6545]
[null,"Banana","Africa",2434,{"$f":"Cell_Color_Code","v":0},null,null,null,null,"Banana","Africa",2434]
[null,"Apple","Europe",4766,{"$f":"Cell_Color_Code","v":6},null,null,null,null,"Apple","Europe",4766]
[null,"Mango","Europe",6600,{"$f":"Cell_Color_Code","v":10},null,null,null,null,"Mango","Europe",6600]
[null,"Total Sales of Apple (Yellow)",null,null,{"$f":"SUMIF(E5:E13,6,D5:D13)","v":14244},null,null,null,null,"Total Sales of Apple (Yellow)"]

{"sheet":"SUMIF_Color_Name","index":2,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[13,1,13,3],[1,9,1,12],[13,9,13,11]]}
[]
[null,"SUMIF Based on Cell Color Name",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product","Region","Sales","Color",null,null,null,null,"Product","Region","Sales","Color"]
[null,"Apple","Asia",4678,"Yellow",null,null,null,null,"Apple","Asia",4678,"Yellow"]
[null,"Mango","Africa",6789,"Green",null,null,null,null,"Mango","Africa",6789,"Green"]
[null,"Banana","Europe",2656,"No Fill",null,null,null,null,"Banana","Europe",2656,"No Fill"]
[null,"Apple","Africa",4800,"Yellow",null,null,null,null,"Apple","Africa",4800,"Yellow"]
[null,"Banana","Asia",2589,"No Fill",null,null,null,null,"Banana","Asia",2589,"No Fill"]
[null,"Mango","Asia",6545,"Green",null,null,null,null,"Mango","Asia",6545,"Green"]
[null,"Banana","Africa",2434,"No Fill",null,null,null,null,"Banana","Africa",2434,"No Fill"]
[null,"Apple","Europe",4766,"Yellow",null,null,null,null,"Apple","Europe",4766,"Yellow"]
[null,"Mango","Europe",6600,"Green",null,null,null,null,"Mango","Europe",6600,"Green"]
[null,"Total Sales of Apple (Yellow)",null,null,{"$f":"SUMIF(E5:E13,\"Yellow\",D5:D13)","v":14244},null,null,null,null,"Total Sales of Apple (Yellow)"]

{"sheet":"VBA","index":3,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Applying SUMIF Function with VBA",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product","Region","Sales","Color Code",null,null,null,null,"Product","Region","Sales","Color Code"]
[null,"Apple","Asia",4678,{"$f":"Cell_Color_Code","v":6},null,null,null,null,"Apple","Asia",4678,{"$f":"Cell_Color_Code","v":6}]
[null,"Mango","Africa",6789,{"$f":"Cell_Color_Code","v":10},null,null,null,null,"Mango","Africa",6789,{"$f":"Cell_Color_Code","v":10}]
[null,"Banana","Europe",2656,{"$f":"Cell_Color_Code","v":0},null,null,null,null,"Banana","Europe",2656,{"$f":"Cell_Color_Code","v":0}]
[null,"Apple","Africa",4800,{"$f":"Cell_Color_Code","v":6},null,null,null,null,"Apple","Africa",4800,{"$f":"Cell_Color_Code","v":6}]
[null,"Banana","Asia",2589,{"$f":"Cell_Color_Code","v":0},null,null,null,null,"Banana","Asia",2589,{"$f":"Cell_Color_Code","v":0}]
[null,"Mango","Asia",6545,{"$f":"Cell_Color_Code","v":10},null,null,null,null,"Mango","Asia",6545,{"$f":"Cell_Color_Code","v":10}]
[null,"Banana","Africa",2434,{"$f":"Cell_Color_Code","v":0},null,null,null,null,"Banana","Africa",2434,{"$f":"Cell_Color_Code","v":0}]
[null,"Apple","Europe",4766,{"$f":"Cell_Color_Code","v":6},null,null,null,null,"Apple","Europe",4766,{"$f":"Cell_Color_Code","v":6}]
[null,"Mango","Europe",6600,{"$f":"Cell_Color_Code","v":10},null,null,null,null,"Mango","Europe",6600,{"$f":"Cell_Color_Code","v":10}]

{"sheet":"UserForm","index":4,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Applying SUMIF Function with UserForm",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product","Region","Sales","Color",null,null,null,null,"Product","Region","Sales","Color"]
[null,"Apple","Asia",4678,"Yellow",null,null,null,null,"Apple","Asia",4678,"Yellow"]
[null,"Mango","Africa",6789,"Green",null,null,null,null,"Mango","Africa",6789,"Green"]
[null,"Banana","Europe",2656,"No Fill",null,null,null,null,"Banana","Europe",2656,"No Fill"]
[null,"Apple","Africa",4800,"Yellow",null,null,null,null,"Apple","Africa",4800,"Yellow"]
[null,"Banana","Asia",2589,"No Fill",null,null,null,null,"Banana","Asia",2589,"No Fill"]
[null,"Mango","Asia",6545,"Green",null,null,null,null,"Mango","Asia",6545,"Green"]
[null,"Banana","Africa",2434,"No Fill",null,null,null,null,"Banana","Africa",2434,"No Fill"]
[null,"Apple","Europe",4766,"Yellow",null,null,null,null,"Apple","Europe",4766,"Yellow"]
[null,"Mango","Europe",6600,"Green",null,null,null,null,"Mango","Europe",6600,"Green"]

{"sheet":"Filter_SUBTOTAL","index":5,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,3],[13,1,13,2],[18,1,18,3]]}
[]
[null,"Using Filter Feature with SUBTOTAL Function"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","Asia",4678]
[null,"Mango","Africa",6789]
[null,"Banana","Europe",2656]
[null,"Apple","Africa",4800]
[null,"Banana","Asia",2589]
[null,"Mango","Asia",6545]
[null,"Banana","Africa",2434]
[null,"Apple","Europe",4766]
[null,"Mango","Europe",6600]
[null,"Total Sales of Apple (Yellow)",null,{"$f":"SUBTOTAL(9,D5:D13)","v":14244}]
[]
[]
[]
[]
[null,"Try Yourself"]
[]
[null,"Product","Region","Sales"]
[null,"Apple","Asia",4678]
[null,"Mango","Africa",6789]
[null,"Banana","Europe",2656]
[null,"Apple","Africa",4800]
[null,"Banana","Asia",2589]
[null,"Mango","Asia",6545]
[null,"Banana","Africa",2434]
[null,"Apple","Europe",4766]
[null,"Mango","Europe",6600]

{"sheet":"SUM_SUMIFS_Functions","index":6,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[13,1,13,3],[1,9,1,12],[13,9,13,11]]}
[]
[null,"Using SUMIFS Function to Sum All Colored Cells",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product","Region","Sales","Color",null,null,null,null,"Product","Region","Sales","Color"]
[null,"Apple","Asia",4678,"Yellow",null,null,null,null,"Apple","Asia",4678,"Yellow"]
[null,"Mango","Africa",6789,"Green",null,null,null,null,"Mango","Africa",6789,"Green"]
[null,"Banana","Europe",2656,"No Fill",null,null,null,null,"Banana","Europe",2656,"No Fill"]
[null,"Apple","Africa",4800,"Yellow",null,null,null,null,"Apple","Africa",4800,"Yellow"]
[null,"Banana","Asia",2589,"No Fill",null,null,null,null,"Banana","Asia",2589,"No Fill"]
[null,"Mango","Asia",6545,"Green",null,null,null,null,"Mango","Asia",6545,"Green"]
[null,"Banana","Africa",2434,"No Fill",null,null,null,null,"Banana","Africa",2434,"No Fill"]
[null,"Apple","Europe",4766,"Yellow",null,null,null,null,"Apple","Europe",4766,"Yellow"]
[null,"Mango","Europe",6600,"Green",null,null,null,null,"Mango","Europe",6600,"Green"]
[null,"Total Sales of Apple and Mango",null,null,{"$f":"SUM(SUMIFS(D5:D13,E5:E13,{\"Yellow\",\"Green\"}))","v":34178},null,null,null,null,"Total Sales of Apple and Mango"]

{"sheet":"COUNTIF","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[13,1,13,3]]}
[]
[null,"Using COUNTIF Function to Count Specific Colored Cells "]
[]
[null,"Product","Region","Sales","Color"]
[null,"Apple","Asia",4678,"Yellow"]
[null,"Mango","Africa",6789,"Green"]
[null,"Banana","Europe",2656,"No Fill"]
[null,"Apple","Africa",4800,"Yellow"]
[null,"Banana","Asia",2589,"No Fill"]
[null,"Mango","Asia",6545,"Green"]
[null,"Banana","Africa",2434,"No Fill"]
[null,"Apple","Europe",4766,"Yellow"]
[null,"Mango","Europe",6600,"Green"]
[null,"Number of Regions of Apple (Yellow)",null,null,{"$f":"COUNTIF(E5:E13,\"Yellow\")","v":3}]