Our task is to create a single list of values repeated across any two columns. We’ll start with quarters 1 and 2. With a quick glance, we can easily see that June is in both columns.

COUNTIF () is a helpful way to count specific values in a list, but you may also run into situations where you want to count items in a filtered list. Let’s cover how to do that next.