Sum and count colored cells in Excel

This utility sums and counts cells based on font or background color and shows average, minimum and maximum values in a range. It is up to you to choose whether to count and sum cells by only one color or by all colors in your worksheet.

No, there are no native ways to sum and count by color. The only way to count colored cells in Excel without additional tools is to write your own VBA code.

Select the range, click on the Sum by Color icon and choose one of the options: Sum and Count by one Color or Sum and Count by All Colors. If you've chosen to work with only one color, click the Color Picker icon next to the Pick any cell with color field and select a pattern cell in your table that represents the formatting you need. Depending on your task, tick either Background or Font. Click the Calculate button and see the result right in the add-in pane. To insert the result, click Paste results button.

Please find a more detailed description here.

Yes, the utility works both for the cells colored manually and with conditional formatting.

Sure! The add-in counts the quantity of colored entries no matter if they are text or numeric cells.

Why not, for this choose the Sum and Count by All Colors option, it works with all the colors used for font or background.

No, you won't have to waste your time on recalculations. Especially for such cases we have added a checkbox Recalculate when selection changes. Tick it off to keep the calculation results always updated.