I have a number of cells which have different fill colours. I would like to
sum these cells so that I have totals for each set of fill coloured cells

How would I go about doing that?

Thanks in advance for your help