Adding Cells

[Kyle Sweeney]

I have cells that are different colors ( to represent differnt items). If i
want to make a fomula that added on the cells that were a certian color, how
would i be able to do that?

Thanks

 

[Paul Sheppard]

I have cells that are different colors ( to represent differnt items).
If i
want to make a fomula that added on the cells that were a certian
color, how
would i be able to do that?

Thanks

Hi Kyle

Take a look at this, it may help

http://www.xldynamic.com/source/xld.ColourCounter.html#summing

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html

 

[Kyle Sweeney]

I am sorry but that information confused me more than i was before.....
the colors i use are yellow, red, green, white and grey
ex: if i wanted to add how many yellow were in colum 1 how would i do the
function
same for red...... green..... white ...... grey

 

[dominicb]

Good morning Kyle

If the VBA issue confuses you, I have a free add in available that will
allow you to identify colours in cells and sum cells by colour - this
will avoid the need for you to use VBA and just use simple fomulas. If
you would like this, please send me an e-mail.

HTH

DominicB
(e-mail address removed)