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.

Some benefits to using GROUPBY over a PivotTable are that it is formula-based, it updates dynamically, and it is easy to use in reports (it does not require setup). In cell G1, enter the GROUPBY ...