Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and manipulate the data accordingly. Some knowledge of programming concepts ...

How to easily sum values by a cell’s background color in ... A SUM() function evaluates all the values in the Invoice Amount, regardless of filtering. SUBTOTAL() can evaluate all the values ...