{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Contents","Sheet1","Sheet1 (2)"],"not_rendered":{"charts":0,"images":2,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["COUNT SUM CELL COLOR"]
[null,"automateexcel.com/formulas/count-sum-cell-color/"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Sheet1",null,null,null,"Excel Formulas w/Examples"]
[null,"Sheet1 (2)",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,null,null,null,null,"Excel Functions & Formulas Tutorial"]
[]
[]
[]
[]
[]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Sheet1","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"January","February","March","April"]
[null,1,10,7,7]
[null,5,12,2,5]
[null,10,5,6,62,null,{"$f":"CountCellsByColor(B3:E11,G5)","v":22},"Count of Orange Cells"]
[null,7,8,6,5,null,{"$f":"CountCellsByColor(B3:E11,G6)","v":14},"Count of Green Cells"]
[null,4,2,5,11]
[null,5,45,5,9,null,{"$f":"SumCellsByColor(B3:E11,G8)","v":231},"Sum of Orange Cells"]
[null,1,3,4,61,null,{"$f":"SumCellsByColor(B3:E11,G9)","v":136},"Sum of Green Cells"]
[null,5,8,null,5]
[null,12,10,3,11]
[]
[null,"automateexcel.com/formulas/count-sum-cell-color/"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sheet1 (2)","index":2,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,1,10,7,7,null,{"$f":"CountCellsByColor(B3:E10,G3)","v":16},"Count of RED Cells"]
[null,5,12,2,5,null,{"$f":"CountCellsByColor(B3:E10,G4)","v":9},"Count of Yellow Cells"]
[null,10,5,6,62,null,{"$f":"CountCellsByColor(B3:E10,G5)","v":7},"Count of Green Cells"]
[null,7,8,6,5]
[null,4,2,5,11]
[null,5,45,5,9,null,{"$f":"SumCellsByColor(B3:E10,G8)","v":184},"Sum of RED Cells"]
[null,1,3,4,61,null,{"$f":"SumCellsByColor(B3:E10,G9)","v":58},"Sum of Yellow Cells"]
[null,5,8,2,5,null,{"$f":"SumCellsByColor(B3:E10,G10)","v":91},"Sum of Green Cells"]
[]
[null,"automateexcel.com/formulas/count-sum-cell-color/"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]