How to find missing values with COUNTIF

In this video, we take a look at how to use the COUNTIF function to solve a common problem: how to count values in one list that also appear in another list. We also "flip" the formula to count values in one list that are missing in another list.