To count colored cells in Microsoft Excel, you may use the Find and Select tool or the Excel Filter and SUBTOTAL() function.

Now, let’s look at a simple example. Specifically, let’s use Subtotal to return a count of the number of books due back on each date in the Due column in the sheet below.

For many years, I used the SUBTOTAL function in Microsoft Excel to create easily visible subtotals at the top of my worksheets. However, when I encountered AGGREGATE, this became my go-to function ...

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.