Using the color rendering index, a measure of how well a light bulb illuminates a range of colors. Appliance Science looks at the science behind testing the quality of light bulbs and the CRI.

Excel does not have a built-in feature to sum or count cells by color, but this can be achieved using three methods: Filtering with Subtotal, Name Manager with Helper Columns, or Custom VBA Functions.