#COUNT BY COLOR EXCEL 2016 HOW TO#
#COUNT BY COLOR EXCEL 2016 CODE#
#COUNT BY COLOR EXCEL 2016 TRIAL#

Kutools for Excel also provides an easy feature- Count by Color, with this utility, you can quickly get the calculation result such as count, sum, average cells and so on by the background color, font color, conditional formatting as you need.

#COUNT BY COLOR EXCEL 2016 TRIAL#

See screenshot:Ĭlick to Download Kutools for Excel and free trial Now! And then, click OK button, you will get the first sum result, to get other results, you just need to copy this formula and change the cell references to your need. In the Function Arguments dialog box, specify the data range and color index cell that you want to sum by font color, see screenshot:ģ. Click a cell where you want to put the count result, and then click Kutools > Kutools Functions > Statistical & Math > SUMBYFONTCOLOR,see screenshot:Ģ. And then, click OK button, you will get the first count result, to get other results, you just need to copy this formula and change the cell references to your need. In the Function Arguments dialog box, specify the data range and color index cell that you want to count by font color, see screenshot:ģ. Click a cell where you want to put the count result, and then click Kutools > Kutools Functions > Statistical & Math > COUNTBYFONTCOLOR,see screenshot:Ģ. Tips: To apply this COUNTBYFONTCOLOR and SUMBYFONTCOLOR features, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.Īfter installing Kutools for Excel, please do as this: Count cells based on font colors:ġ. May be the User Defined Function is troublesome for you to save and apply, here, I will recommend you a handy tool- Kutools for Excel, with its advanced functions, you can solve this task quickly and easily. If you want to sum other font colored cells, please repeatedly enter the formula. Then press Enter key, and you will add up all cells with red font colors.

Note: In the above formula, A1:D10 is the range that you want to use and A2 is the cell with a particular font color that you want to sum.Ĥ.

#COUNT BY COLOR EXCEL 2016 CODE#

Then save this code and return to the original worksheet, and then enter this formula =SumB圜olor(A1:D8,A1) into a blank cell, see screenshot: VBA code: Sum cells based on font colors: Public Function SumB圜olor(pRange1 As Range, pRange2 As Range) As Doubleģ. To sum cells based on font colors, the following User Defined Function can help you. If you want to count other font colored cells, please repeatedly enter the formula as possible as you need. After typing the formula, press Enter key, and you will get the number of cells with red font colors. Note: In the above formula, A1:D10 is the range that you want to use and A2 is the cell with a particular font color that you want to count.Ĥ.

Then save this code and go back to the worksheet, and then enter this formula in to a blank cell =CountColour(A1:D10,A2), see screenshot: VBA code: Count cells based on font colors: Public Function CountColour(pRange1 As Range, pRange2 As Range) As Double Click Insert > Module, and paste the following code in the Module Window. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.Ģ. To calculate the number of cells with specific font colors, please do as these:ġ. Normally, there is no direct way to deal with this task, here, I will talk about some tricks for soling this job.Ĭount or sum cells based on font colors with User Defined FunctionĬount or sum cells based on font color with some useful functionsĬount or sum cells based on font color with an amazing feature-Count by ColorĬount or sum cells based on font colors with User Defined Function Count cells based on font colors: How could you get the number of cells or sum all the cells which contain a particular font color in Excel? For example, I have a range of data in a worksheet as following screenshot shown, and now I want to respectively count or sum the cells that have a red, blue and black font color.

#COUNT BY COLOR EXCEL 2016 HOW TO#

How to count or sum cells based on the font colors in Excel?

Count by color excel 2016