Forum Discussion
Formula to count a range of text values and count by cell color.
I have attached a file with data to explain the formula(s) I am seeking. In brief, how to count a range of grades in one formula and whether a range of grades can be counted by cell color.
Thanks Sergei!
Also, the example showing Column R with text in colored cells. Is there a formula to count the cells by color?
Tom, if you mean to check only color of the cell, not value - when not, at least by formulas (could be done using VBA). The color is the property of the cell, and formulas work with values.
But since you have conditional formatting you may use exactly the same expressions as in rules to calculated number of your coloured cells.
Perhaps i don't understand something, but i see no difference between counting as in previous time and summing. You may use same SUMPRODUCT as well. Please clarify if i'm wrong.