nsaculture.blogg.se

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.Ĥ. 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. How to count or sum cells based on the font colors in Excel?