Sum cells by fill colour

[jamiemal]

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

 

[JE McGimpsey]

See

http://cpearson.com/excel/colors.htm

 

[Dave Peterson]

Take a look at Chip Pearson's site:
http://www.cpearson.com/excel/colors.htm

Look for a function named: SumByColor

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm