AblebitsCountByFontColor function

The AblebitsCountByFontColor function counts the number of cells that contain numbers with the specified in the argument font color.

For example:

  • =AblebitsCountByFontColor(C3:I9,N22) Counts the number of cells in the C3:I9 range that contain numbers and have the same font color as the N22 cell.
  • =AblebitsCountByFontColor(C3:I9,255) Counts the number of cells in the C3:I9 range that contain numbers and have the font color of 255 color code.
Note. Formulas created with this function will work only on machines with installed Ultimate Suite for Excel. If the workbook is opened on another computer where Ultimate Suite is not installed, the result will be lost.
Tip. You can find the complete list of custom functions on the Ablebits functions for Excel page.

Syntax

AblebitsCountByFontColor(range,color)

The AblebitsCountByFontColor function syntax has the following arguments:

  • range
    Required. The range to count cells with numbers, e.g. B2:B8.
  • color
    Required. The font color of cells that contain numbers and should be counted. Can be a reference to one cell like B6 or color code like 255.
Note. The range can refer to a variety of different types of data, but only cells with numbers are counted.

Remarks

  • To count all cells with a certain font color, not only those that contain numbers, use the AblebitsCountAByFontColor function.
  • The AblebitsCountByFontColor function is used by the Count and Sum by Color add-in when you check the Insert result as formula box before pasting the result.
  • If you want to get the color code of the font color of a cell, you can use the AblebitsGetCellFontColor function.
  • Multiple ranges are not supported.
  • The function does not work for conditionally formatted cells and for ranges formatted as tables with colored alternate rows or columns.