Today, we are going to learn the steps to count missing values in a list in Excel Office 365 with an example. To do this task, we will use SUMPRODUCT and COUNTIF function. This article will provide the simple steps for you to achieve the task. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Check this too: Find and Fill Missing Numbers in a Sequence in Excel Office 365
Count missing values in a list:
To count the missing data from the specific range in Excel, you need to follow the below steps.
- For instance, you need to create two lists of items that are the actual list ( essential ) and received items ( received ) as shown in the below image.
- Now, we are going to check the list and get the missing values from it.
- To do this, you can use the following formula.
=SUMPRODUCT(–(COUNTIF(Range1,Range2)=0))
- Range1 – It is the checklist range in Excel.
Range2 – This is the range that contains the actual list of items.
You have to enter the formula in the cell where you want to get the result.
- After applying the formula, press the Enter key to see the result as shown in the below image.
Sum-Up:
In the above article, we have demonstrated the simple steps to count missing values in a list in Excel Office 365 with an example. Give your worthwhile feedback in the below comment section. Thanks for visiting Geek Excel.
Related Posts:
- Excel Formulas to Highlight Cells that begin with a Given Criteria!!
- Excel Formulas to Create Gantt Chart with Time Schedule!!
- How to Compare Two Ranges using Macros (VBA) in Excel 365?
- Hide Rows with Zero Value using Macros (VBA) in Excel Office 365!
- Use Data Validation with No Punctuation in Excel Office 365!!
Top comments (0)