The AblebitsAvgByColor function returns the average (arithmetic mean) of numbers in cells with the specified in the argument background color.
=AblebitsAvgByColor(C3:I9,N22) Returns the average (arithmetic mean) of numbers in a range of cells C3:I9 that have the same background color as the N22 cell.
=AblebitsAvgByColor(C3:I9,255) Returns the average (arithmetic mean) of numbers in a range of cells C3:I9 that have the background color of 255 color code.
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.
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 email@example.com.