Ukraine flag War in Ukraine. Here's what Ablebits is doing to make sure our team and projects are safe.

AblebitsCountAByFontColor function

The AblebitsCountAByFontColor function counts the number of cells with the specified font color. Can include empty cells or not depending on the argument.

For example:

  • =AblebitsCountAByFontColor(C3:I9,N22) Counts the number of non-blank cells with the same font color as the N22 cell in the range C3:I9.
  • =AblebitsCountAByFontColor(C3:I9,N22,FALSE) Counts the number of all cells (both empty and not empty) that have the same font color as the N22 cell in the range C3:I9.
  • =AblebitsCountAByFontColor(C3:I9,255) Counts the number of non-blank cells with the font color of 255 color code in the range C3:I9.
  • =AblebitsCountAByFontColor(C3:I9,255,FALSE) Counts the number of all cells (both empty and not empty) that have the font color of 255 color code in the range C3:I9.
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

AblebitsCountAByFontColor(range,color,skip_empty_cells)

The AblebitsCountAByFontColor function syntax has the following arguments:

  • range
    Required. The range of cells you want to count, e.g. B2:B8.
  • color
    Required. The font color of cells that should be counted. Can be a reference to one cell like B6 or color code like 255.
  • skip_empty_cells
    Optional: TRUE or FALSE. If you do not add this argument, the result will equal to TRUE and will not include empty cells into the count. However, if you add the FALSE argument, empty cells will be counted.

Remarks

  • The AblebitsCountAByFontColor 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.
  • If you do not need to count logical values, text, or error values (in other words, if you want to count only colored cells that contain numbers), use the AblebitsCountByFontColor function.
  • The function does not work for conditionally formatted cells and for ranges formatted as tables with colored alternate rows or columns.