I have a chart and want to know how I can get the sum of coloured cell? Is
there a macro or a function where I can do that?

i.e

I have Cells C3:R3 and (cells E3, H3, I3,J3 and N3 is coloured ) I want S3
to show the total (5)

Thank you