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:
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. |
