Dear Leith, You seem like a color count hero ;-). In post http://www.excelforum.com/excel-prog...ml#post2605411 you helped Greed perfectly. I have a similar problem, it would be great if you could help me with it. 1) Key issue: I need Excel to count the number of cells that meet Criteria A (text), Criteria B (text) and Criteria C (red color). I tried to do this with: =Countifs (range “column A”, Criteria A “text”, range “column B”, Criteria B “text”, range “column C”, Criteria C color red). For Criteria C I however do not know which formula to use to get the criteria “red cell”. I would not like to add additional columns, everything should be in one formula. I tried all, but nothing worked. I run the color module by Chip Pearson, but this gave an error message. Hope you’ll be able to provide me with the answer… Many thanks! Alinda
