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.

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.

Responses

NIZAMADDEEN UMAR says:
April 12, 2023 at 3:24 pm

Please sir, I have an original data with my old data added by individual outside so I want compare the data to get those added which I am unaware of . please how can I go with this urgent sir

Ekaterina Pechyonkina (Ablebits Team) says:
April 12, 2023 at 3:37 pm

Hello,

For us to be able to help you better, please send us a small sample workbook with your source data and the result you expect to get to support@ablebits.com. I kindly ask you to shorten the tables to 10-20 rows.
Note! The result sheet is of great importance and often gives us a better understanding of your task rather than any text description. Please don't forget to include it.
We'll look into your task and see if our software can help.

Leona says:
March 3, 2022 at 10:48 pm

Is the option to insert these as custom functions only available to windows users?

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.