sum cells based upon color of cell

[Guest]

I have a worksheet with color coded cells and numerical data in each cell.
I'd like to tally the contents of the various colors. Any suggestions?

 

[Gord Dibben]

karls

Excel default functions cannot count or sum by color format.

See Chip Pearson's site for VBA code.

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

If cells are shaded due to Conditional Formatting you could possibly sum by
those conditions.


Gord Dibben Excel MVP

 

[Guest]

You would need code for that


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


Regards,

Peo Sjoblom