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.

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.

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.
Ablebits.com on Facebook Ablebits Youtube channel
Copyright © 2003 - 2021 4Bits Ltd. All rights reserved.   Privacy policy   Terms of use   Contact us
Microsoft and the Office logos are trademarks or registered trademarks of Microsoft Corporation. Google Chrome is a trademark of Google LLC.