Excel Formulas to Find the Missing Values From a list!!
Tags: excel, excelformula, excelformulas
Published: 2020-12-18 10:17:57

---
title: Excel Formulas to Find the Missing Values From a list!!
published: true
date: 2020-12-18 10:15:31 UTC
tags: Excel,ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-missing-values-from-a-list/
---

For instance, You have a list of values, and you need to check some values are present or not on the list. How could you achieve this job quickly? Let’s get into this article!!

Here, we will discuss how to **find the missing values from a listed range in Excel**. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to count the missing values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-count-the-missing-values.png)](https://geekexcel.com/excel-formulas-find-missing-values-from-a-list/formulas-to-count-the-missing-values/#main)<figcaption id="caption-attachment-19970">Formulas to count the missing values</figcaption>
## Generic Formula:

- The below formula will help to find the missing values.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(–(COUNTIF(list1,list2)=0))**

## Syntax Explanations:

- **SUMPRODUCT** – The **[SUMPRODUCT function](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)** multiplies the corresponding arrays or ranges and returns the sum of the products.
- **COUNTIF** – In Excel, this function is used to count the cells that meet a single condition or criteria.
- **List** – It represents the input ranges in a worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Minus Operator (-)** – This symbol will help to subtract any two values.

## Practical Example:

- Let’s see the below example image to find the missing value.
- First, we will give the inputs in **Column B** and **Column C**.
- Then, enter the given formula in the formula bar section.
- After applying the formula, it will display the result in the selected **cell G4**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-66.png)<figcaption id="caption-attachment-19969">Example</figcaption>

## Closure:

In this tutorial, you can get to know the simple formula to **find the missing values from a list in Excel**. Mention your queries in the comment box below. Thank you. To learn more, check out **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Find the Nth Largest Value From a set of data!!](https://geekexcel.com/wp-admin/post.php?post=19722&action=edit)**
- **[Excel Formulas to Find the Minimum Value With Multiple Criteria!!](https://geekexcel.com/wp-admin/post.php?post=19579&action=edit)**
- [**Formulas to Find the Name of Nth Largest Value with Criteria!!**](https://geekexcel.com/wp-admin/post.php?post=19704&action=edit)