Adding Cells

K

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
 
K

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
 
D

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
[email protected]
 
Top