Formulas to Count Numbers where the Nth Digit equal to Specific Number!!
Tags: excelformula, excelformulas
Published: 2020-11-06 12:00:13

---
title: Formulas to Count Numbers where the Nth Digit equal to Specific Number!!
published: true
date: 2020-11-06 09:20:32 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-count-numbers-where-the-nth-digit-equal-to-specific-number/
---

In this article, we will guide you to learn **Formulas to count numbers by a range where the Nth digit equal to a specific number or value in Excel Office 365**. Let’s see them below!! 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 numbers where the Nth digit equals to Specific number](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-numbers-where-the-Nth-digit-equals-to-Specific-number.png)](https://geekexcel.com/formulas-to-count-numbers-where-the-nth-digit-equal-to-specific-number/formulas-to-count-numbers-where-the-nth-digit-equals-to-specific-number/#main)<figcaption id="caption-attachment-17004">Formulas to count numbers where the Nth digit equal to a Specific number</figcaption>
## General Formula:

- The below formula will help to count the numbers where the Nth digit equal to a specific number in Excel.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(–([MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)(range,digit,character)=”X”))**

## Syntax Explanations:

- **SUMPRODUCT** – The Excel **[SUMPRODUCT Function](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)** will multiply the corresponding array or range and returns as the sum of the products.
- **MID** – This function is used to extract the number or character from the given string. You can also customize the position. Read more on [**MID Function**](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/).
- **Range** – It represents the input values given in a worksheet.
- **Digit** – It is the position of the given input that is equal to a certain number.
- **Character** – In this formula, it represents the number of character which is to be count.
- **Criteria (X)-** It is the criteria that are used to count the cells.
- **Comma symbol (,)** – It is a separator which 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.

## Example:

- Let’s consider the below example to count the numbers where the nth digit equals to a certain value.
- First, you need to give the input values.
- After that, enter the given formula in the selected area.
- Finally, you can get the result as per the given image.

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

## Verdict:

In this tutorial, we explained the **Formulas used for counting the numbers by a range where the Nth digit equal to a specific number or value in Excel Office 365**. Hope that this article is useful to you. If you have any **suggestions,** feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Formulas for counting the cells that contain Errors in Excel Office 365!!](https://geekexcel.com/formulas-for-counting-the-cells-that-contain-errors-in-excel-office-365/)**
- [**Formulas to Count Cells that contain numbers in Excel Office 365!!**](https://geekexcel.com/formulas-to-count-cells-that-contain-numbers-in-excel-office-365/)