Sum cells by fill colour
 

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

See

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


In article ,
"jamiemal" wrote:

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

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

jamiemal wrote:

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

--

Dave Peterson