put "red"/"blue" in a cell (eg A1)
=countif(a2:a20,a1)

"Bruce" ...
How do you countif for 2 conditions?

countif ( A1 = "Red" and "B1 = blue")

Bruce