Ablebits functions for Excel

Ultimate Suite for Excel offers not only handy tools for your daily tasks but also additional functions that you can use in your formulas. On this page, the functions are collected by the add-ins that involve them to create custom formulas. Press Ctrl+F and start typing the keyword to find a function of interest. To get detailed information about a function, click on its name in the first column.

Note. The functions work on Ultimate Suite 2021.3 version and higher.

How to enable Ablebits functions

By default, the Ablebits functions are disabled in your Excel. To enable them, go to the Ablebits Data tab, click Options and check the Enable Ablebits functions option:

Enable Ablebits functions.

After that, close and start Excel anew.

Count and Sum by Color

Function Description
AblebitsSumByColor Adds values in cells with the specified in the argument background color.
AblebitsSumByFontColor Adds values in cells with the specified in the argument font color.
AblebitsCountByColor Counts the number of cells that contain numbers with the specified in the argument background color.
AblebitsCountByFontColor Counts the number of cells that contain numbers with the specified in the argument font color.
AblebitsCountAByColor Counts the number of cells with the specified background color. Can include empty cells or not depending on the argument.
AblebitsCountAByFontColor Counts the number of cells with the specified font color. Can include empty cells or not depending on the argument.
AblebitsAvgByColor

Returns the average (arithmetic mean) of numbers in cells with the specified in the argument background color.
AblebitsAvgByFontColor Returns the average (arithmetic mean) of numbers in cells with the specified in the argument font color.
AblebitsAvgAByColor Calculates the average (arithmetic mean) of numbers in cells with the specified background color. Can include empty cells or not depending on the argument.
AblebitsAvgAByFontColor Calculates the average (arithmetic mean) of numbers in cells with the specified font color. Can include empty cells or not depending on the argument.
AblebitsMaxByColor Returns the largest value in cells with the specified in the argument background color.
AblebitsMaxByFontColor Returns the largest value in cells with the specified in the argument font color.
AblebitsMinByColor Returns the smallest value in cells with the specified in the argument background color.
AblebitsMinByFontColor Returns the smallest value in cells with the specified in the argument font color.
AblebitsGetCellColor Returns the color code of the background color of the selected cell.
AblebitsGetCellFontColor Returns the color code of the font color of the selected cell.

Spell Number

Function Description
AblebitsSpellNumber Converts numbers to words.

Regex Tools

Function Description
AblebitsRegexMatch Searches for text that matches the specified regular expression, and then returns TRUE if match is found and FALSE if not.
AblebitsRegexExtract Returns a match with the specified regular expression in a cell.
AblebitsRegexRemove Removes a match with the specified regular expression in a cell.
AblebitsRegexReplace Replaces a match with the specified regular expression in a cell.