Hi and welcome
if the color comes from conditional formatting it's rather easy.Just sum the numbers which answer the condition.


If not VBA is needed ( there are UDF's on the Net I think)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post