Hi
I got 2 x solutions for two different problems, and sorted both of them out. Now I have a need to combine these solutions, as follows:
First Problem: I needed to count cells by formatting. The solution was to place some VBA code in a module and use the "ColorFunction(O4,$C$3:$L$33,FALSE)" formula, where the format to be counted was in O4, and the range of cells to count is C3:L33.
Second Problem: I wanted to count cells which contain a specific string of text, and the solution was the formula "COUNTIF(C3:L33,"*"&O11)", where the text string to be counted was contained in O11.
For the same situation and data range, I now need to count the cells in C3:L33 where the last three characters are = the value in O11 AND where the format is equal to the format in O4.
I considered a SUMPRODUCT but dont know how to set it up? Is there an easier way?
I got 2 x solutions for two different problems, and sorted both of them out. Now I have a need to combine these solutions, as follows:
First Problem: I needed to count cells by formatting. The solution was to place some VBA code in a module and use the "ColorFunction(O4,$C$3:$L$33,FALSE)" formula, where the format to be counted was in O4, and the range of cells to count is C3:L33.
Second Problem: I wanted to count cells which contain a specific string of text, and the solution was the formula "COUNTIF(C3:L33,"*"&O11)", where the text string to be counted was contained in O11.
For the same situation and data range, I now need to count the cells in C3:L33 where the last three characters are = the value in O11 AND where the format is equal to the format in O4.
I considered a SUMPRODUCT but dont know how to set it up? Is there an easier way?
