You can filter on color, but I don't believe you can sum on a color.

Probably it can be done with VBA, but that is not my expertice.


If you can add why the cells are collered, we can use that argument in a formula.