{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Contents","Sheet1","Sheet1 (2)"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Contents","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"merged":[[0,0,0,1]]}
["COUNT SUM CELL COLOR"]
[null,"formulas/count-sum-cell-color/"]
[]
[null,"Table of Contents"]
[null,"Sheet1"]
[null,"Sheet1 (2)"]

{"sheet":"Sheet1","index":1,"n_rows":13,"n_cols":8,"rows_kept":13}
[]
[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":{"$error":"#VALUE!"}},"Count of Orange Cells"]
[null,7,8,6,5,null,{"$f":"CountCellsByColor(B3:E11,G6)","v":{"$error":"#VALUE!"}},"Count of Green Cells"]
[null,4,2,5,11]
[null,5,45,5,9,null,{"$f":"SumCellsByColor(B3:E11,G8)","v":{"$error":"#VALUE!"}},"Sum of Orange Cells"]
[null,1,3,4,61,null,{"$f":"SumCellsByColor(B3:E11,G9)","v":{"$error":"#VALUE!"}},"Sum of Green Cells"]
[null,5,8,null,5]
[null,12,10,3,11]
[]
[null,"formulas/count-sum-cell-color/"]

{"sheet":"Sheet1 (2)","index":2,"n_rows":12,"n_cols":8,"rows_kept":12}
[]
[]
[null,1,10,7,7,null,{"$f":"CountCellsByColor(B3:E10,G3)","v":{"$error":"#VALUE!"}},"Count of RED Cells"]
[null,5,12,2,5,null,{"$f":"CountCellsByColor(B3:E10,G4)","v":{"$error":"#VALUE!"}},"Count of Yellow Cells"]
[null,10,5,6,62,null,{"$f":"CountCellsByColor(B3:E10,G5)","v":{"$error":"#VALUE!"}},"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":{"$error":"#VALUE!"}},"Sum of RED Cells"]
[null,1,3,4,61,null,{"$f":"SumCellsByColor(B3:E10,G9)","v":{"$error":"#VALUE!"}},"Sum of Yellow Cells"]
[null,5,8,2,5,null,{"$f":"SumCellsByColor(B3:E10,G10)","v":{"$error":"#VALUE!"}},"Sum of Green Cells"]
[]
[null,"formulas/count-sum-cell-color/"]