Sum of Colored Cells

[Tester Testings]

hi all,
suppose i have a range of cells, and that range needs to summed depanding on
the cells color.
for example, i need to sum the cells colored with green in one cell, and the
cells colored with red in another cell and so the blue ones.
is there any way to do that?

many thanks in advance.

 

[Dave Peterson]

You're going to need a macro.

Chip Pearson has lots at:
http://cpearson.com/excel/Colors.aspx

Look for SumColor on that page.

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

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)