Gsheets COUNTIF formula

[yessir]

I'm looking to create a formula to count unique words based on condition in a separate cell

A B C

Coverage		County
No Coverage		Santa Clara
Coverage		San Diego
No Coverage		Santa Clara
No Coverage		Sonoma
Coverage		Los Angeles

In this case I would want to count the number of counties (column C) where there is "no coverage" in column A. However, I wouldn't want to count the same county twice. So in the example above the formula would display the number "2" because we don't have coverage in Santa Clara as well as Sonoma. Is this possible?

 

[Fluff]

How about

=ROWS(UNIQUE(FILTER(C2:C100,A2:A100="no coverage")))