Method 1: Filtering with the Subtotal Function This method uses Excel’s built-in filter feature in combination with the `SUBTOTAL` function to sum or count cells by color.

The SUBTOTAL Function Microsoft Excel's SUBTOTAL function is quite simple to use. It lets you perform subtotal calculations for ranges of cells, and you can decide whether you want to include ...