O onyx4813 Aug 15, 2005 #1 What formula do I use to add all numbers in different cells that are blue in color or red in color or green in color?
What formula do I use to add all numbers in different cells that are blue in color or red in color or green in color?
D dominicb Aug 15, 2005 #3 Good afternoon onyx4813 Unfortunately no such function exists, but it can be done by writeing custom function. Chip Pearson provides some code that will do just tha on his pages. http://www.cpearson.com/excel/colors.htm HTH Dominic
Good afternoon onyx4813 Unfortunately no such function exists, but it can be done by writeing custom function. Chip Pearson provides some code that will do just tha on his pages. http://www.cpearson.com/excel/colors.htm HTH Dominic
B Bob Phillips Aug 15, 2005 #4 An alternative http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH RP (remove nothere from the email address if mailing direct)
An alternative http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH RP (remove nothere from the email address if mailing direct)
