Adding Cells
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 |
Kyle Sweeney Wrote: 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....r.html#summing -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=467451 |
See http://www.xldynamic.com/source/xld.ColourCounter.html
-- HTH Bob Phillips "Kyle Sweeney" wrote in message ... 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 |
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 "Kyle Sweeney" wrote in message ... 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 |
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 -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=467451 |
All times are GMT +1. The time now is 08:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com