When you are dealing with more than one list, a time comes when you have to confirm for whether you left a value missing.  When you are dealing with more than one list, a time comes when you have to confirm for whether you left a value missing.  When you are dealing with more than one list, a time comes when you have to confirm for whether you left a value missing. 

So, to check your data and count the missing values you can use the countif function

Previously in Excel Tutorials:- How to split the texts and numbers Using Flash Fill in Excel?

To understand it with a clear view, let’s take an example for the same:

COUNTIF function

Here we have taken two lists of food cause who doesn’t love food! 

Now let’s input the formula:

COUNTIF function

The formula to count missing values is 

=COUNTIF(

The following formula requires two things, one is the range and the other is the criteria.

COUNTIF function

Let’s say we want to check for whether the List B items are present in the List A or not, so basically our List A becomes the range.

COUNTIF function

After selecting the same, we come to criteria that is our list B.

Then we press enter. And drag the formula down so that we get a quick answer to all the values instead of jotting down the formula again and again for each value.

COUNTIF function

And as you can see your answer is right in front of you!

COUNTIF function

Through the above image, we can observe that the COUNTIF Function helped us to find out that “pie” as well as “plain fries” were the missing values in List A. 

COUNTIF function

It’s easy, isn’t it?