Count number of cells that contain red, blue or red and blue

SS example:

Red
Green
Red, Blue, Green
Green, 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!

Thanks
Kelly

Getting #VALUE!