Red, Blue, Green
I need a function that will return the number of cells that contain red, blue, OR red and blue.
So the result of the function in this case would be 4.
The COUNTIF(data,"*red*")+COUNTIF(data,"*blue*") function that I am using returns 5, because that is how many times the two words appear. I only want it to count the cell that contains both words once.
Help would be greatly appreciated!