Скачать или смотреть Count or sum cells by fill or font color in Excel

Tutorial: https://www.extendoffice.com/product/...

In Excel, we always format cells with filling color or font color to make the data more outstanding. Sometimes, we need to count or sum the cells based on background color or font color. That is to say, to sum or count the cells which have the same color. Unfortunately, there is no direct way for us to deal with this task in Excel. But, with the help of Kutools for Excel’s Super Functions, this problem will be solved quickly and easily.

COUNTBYCELLCOLOR function: Counting the number of cells by a certain fill color
COUNTBYFONTCOLOR function: Counting the number of cells by a certain font color
COUNTSHADES function: Counting the number of cells that have been filled with color
SUMBYCELLCOLOR function: Sum cells by a certain fill color
SUMBYFONTCOLOR function: Sum cells by a certain font color