Try
=IF(AND(D2="SW",E2="France"),COUNTIF($O2:$O99, "75%"),"")
Where 75% is the condition of green, you can also specify ranges for D2 and
E2 but all in range must meet chriteria.

If this helps click YES.

"KC" wrote:

I need a formula for the following:

If Col D = SW and Col E = France, then count how many green cells are in Col
O. (Column O has conditional formatting of Green, Yellow & Red based on a %,
but I don't want to count the %, just want to count the instances of Green).

Thanks very much!