{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","1. COUNT and SUM","2. COUNTIF & SUMIF","3. IF","4. SUMIFS","5. VBA Macro_1","5.VBA Macro_2"],"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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Name","Quantity"]
[null,"T-shirt",590]
[null,"Hoodie",740]
[null,"Pant",540]
[null,"Jacket",410]
[null,"Blazer",320]
[null,"Sweater",400]

{"sheet":"1. COUNT and SUM","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"COUNT and SUM by Color"]
[]
[null,"Name","Quantity"]
[null,"Hoodie",740]
[null,"Jacket",410]
[null,"Sweater",400]
[]
[]
[null,"Count by Color",3]
[null,"Sum by Color",1550]

{"sheet":"2. COUNTIF & SUMIF","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"COUNTIF and SUMIF by Cell Color"]
[]
[null,"Name","Quantity","Color Code",null,"Color","COUNTIF","SUMIF"]
[null,"T-shirt",590,{"$f":"NumberColor","v":36},null,null,{"$f":"COUNTIF(D5:D10,$D$5)","v":2},{"$f":"SUMIF(D5:D10,$D$5,C5:C10)","v":1130}]
[null,"Hoodie",740,{"$f":"NumberColor","v":40},null,null,{"$f":"COUNTIF(D5:D10,$D$6)","v":3},{"$f":"SUMIF(D5:D10,$D$6,C5:C10)","v":1550}]
[null,"Pant",540,{"$f":"NumberColor","v":36},null,null,{"$f":"COUNTIF(D5:D10,$D$9)","v":1},{"$f":"SUMIF(D5:D10,$D$9,C5:C10)","v":320}]
[null,"Jacket",410,{"$f":"NumberColor","v":40}]
[null,"Blazer",320,{"$f":"NumberColor","v":55}]
[null,"Sweater",400,{"$f":"NumberColor","v":40}]

{"sheet":"3. IF","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3],[12,2,12,3]]}
[]
[null,"IF by Cell Color"]
[]
[null,"Name","Quantity","Color Code","IF "]
[null,"T-shirt",590,{"$f":"NumberColor","v":36},{"$f":"IF(NumberColor=40,C5*$C$13,0)","v":0}]
[null,"Hoodie",740,{"$f":"NumberColor","v":40},{"$f":"IF(NumberColor=40,C6*$C$13,0)","v":3700}]
[null,"Pant",540,{"$f":"NumberColor","v":36},{"$f":"IF(NumberColor=40,C7*$C$13,0)","v":0}]
[null,"Jacket",410,{"$f":"NumberColor","v":40},{"$f":"IF(NumberColor=40,C8*$C$13,0)","v":2050}]
[null,"Blazer",320,{"$f":"NumberColor","v":55},{"$f":"IF(NumberColor=40,C9*$C$13,0)","v":0}]
[null,"Sweater",400,{"$f":"NumberColor","v":40},{"$f":"IF(NumberColor=40,C10*$C$13,0)","v":2000}]
[]
[null,"Price for Hoodie, Jacket & Sweater"]
[null,"Price Per Piece",5]

{"sheet":"4. SUMIFS","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"SUMIFS by Cell Color"]
[]
[null,"Name","Quantity","Color Code","SUMIFS"]
[null,"T-shirt",590,{"$f":"NumberColor","v":36},{"$f":"SUMIFS($C$5:$C$10,$D$5:$D$10,$D5)","v":1130}]
[null,"Hoodie",740,{"$f":"NumberColor","v":40},{"$f":"SUMIFS($C$5:$C$10,$D$5:$D$10,$D6)","v":1550}]
[null,"Pant",540,{"$f":"NumberColor","v":36},1130]
[null,"Jacket",410,{"$f":"NumberColor","v":40},1550]
[null,"Blazer",320,{"$f":"NumberColor","v":55},320]
[null,"Sweater",400,{"$f":"NumberColor","v":40},1550]

{"sheet":"5. VBA Macro_1","index":5,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"VBA Macro To Find Color Code and Apply Formula"]
[]
[null,"Name","Quantity","Color Code","COUNTIF","SUMIF"]
[null,"T-shirt",590,{"$f":"ColorIndex(C5)","v":40},{"$f":"COUNTIF($D$5:$D$10,$D5)","v":2},{"$f":"SUMIF($D$5:$D$10,$D5,$C$5:$C$10)","v":1130}]
[null,"Hoodie",740,{"$f":"ColorIndex(C6)","v":3},3,{"$f":"SUMIF($D$5:$D$10,$D6,$C$5:$C$10)","v":1550}]
[null,"Pant",540,{"$f":"ColorIndex(C7)","v":40},2,1130]
[null,"Jacket",410,{"$f":"ColorIndex(C8)","v":3},3,1550]
[null,"Blazer",320,{"$f":"ColorIndex(C9)","v":55},1,320]
[null,"Sweater",400,{"$f":"ColorIndex(C10)","v":3},3,1550]

{"sheet":"5.VBA Macro_2","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VBA to Directly Sum by Color"]
[]
[null,"Name","Quantity","Sum By Color"]
[null,"T-shirt",590,{"$f":"SBC($C5,$C$5:$C$10)","v":1130}]
[null,"Hoodie",740,{"$f":"SBC($C6,$C$5:$C$10)","v":1550}]
[null,"Pant",540,{"$f":"SBC($C7,$C$5:$C$10)","v":1130}]
[null,"Jacket",410,{"$f":"SBC($C8,$C$5:$C$10)","v":1550}]
[null,"Blazer",320,{"$f":"SBC($C9,$C$5:$C$10)","v":320}]
[null,"Sweater",400,{"$f":"SBC($C10,$C$5:$C$10)","v":1550}]