Hello, thank you for your comment! I considered going into the code analysis, but ultimately decided on the shorter version because 90% of the viewers are only interested in the final solution (not so much in how the code exactly works). I'll upload a version here that explains how the function works. Explanation of the Function: Function SUMBYCOLOR(color As Range, ParamArray ranges() As Variant) As Double ' Declare variables to be used within the function Dim cell As Range Dim targetRange As Variant Dim sumResult As Double ' Initialize the sum result to 0 sumResult = 0 ' Loop through each target range in the ParamArray ranges For Each targetRange In ranges ' Check if the current item in ranges is of type "Range" If TypeName(targetRange) = "Range" Then ' Loop through each cell in the current target range For Each cell In targetRange ' Check if the background color of the current cell matches the reference color If cell.Interior.color = color.Interior.color Then ' If the colors match, add the cell's value to sumResult sumResult = sumResult + cell.Value End If Next cell End If Next targetRange ' Assign the final sumResult to the function's return value SUMBYCOLOR = sumResult End Function

@@excelkid thanks for the reply. VBA code correct