# Learn How to Count Missing Value in Microsoft Excel

Written by | 0 Comments | 341 Views

In this article, you will learn how to evaluate things based on the LOOKUP function in Microsoft Excel using a single/combination(s) of functions. You will also know to Count Missing Value and see the generic formula.

Learn How to Count Missing Value in Microsoft Excel

The main purpose of this formula is to count the values in one list that are missing from another list. Here we will learn how to count missing values in the given data range in the workbook in Microsoft Excel. That implies, with the help of a formula based on the SUMPRODUCT and COUNTIF function you can able to count the values in one list that are missing from another list. So, with the help of this formula, you can able to count missing values in the given data range in the workbook in Microsoft Excel.

General Formula to Count Missing Value

=SUMPRODUCT(--(COUNTIF(list1,list2)=0))

The Explanation to Count Missing Value

So we know that with the help of the given formula above you can able to count the values in one list that are missing from another list. Here we will learn how to count missing values in the given data range in the workbook in Microsoft Excel. As we know that the COUNTIF function checks values in a range for the given criteria. Usually, the one criteria are supplied, but in this case, we supply more than one criteria.

Because we give COUNTIF function more than one criteria, we get more than one result in a result array. So now you have learned how to count missing values in the given data range in the workbook in Microsoft Excel.