Excel Formulas to Count Long Numbers Without COUNTIF Function!!
Tags: excelformula, excelformulas
Published: 2020-11-05 10:10:02

---
title: Excel Formulas to Count Long Numbers Without COUNTIF Function!!
published: true
date: 2020-11-05 08:43:26 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-long-numbers-without-countif-function/
---

Generally, we use the COUNTIF Function for counting the long numbers from a cell in Excel. But, here we will see the **formulas to count the long numbers in a cell without using the COUNTIF Function in Excel Office 365**. Let’s get into this article!! 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 long numbers without using COUNTIF Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-long-numbers-without-using-COUNTIF-Function.png)](https://geekexcel.com/excel-formulas-to-count-long-numbers-without-countif-function/formulas-to-count-long-numbers-without-using-countif-function/#main)<figcaption id="caption-attachment-16914">Formulas to count long numbers without using COUNTIF Function</figcaption>
## General Formula:

- The below formula is used to count the long numbers without using COUNTIF Function.

**=**** [SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)****(–(A: A=A1))**

## Syntax Explanations:

- **SUMPRODUCT** – In Excel, the **[SUMPRODUCT Function](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)** will help to multiply the corresponding array or range and returns as the sum of the product.
- **A: A (Range)** – It represents the input range from your worksheet. It will select the entire Column A.
- **A1 (Criteria)** – It is the criteria that help 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:

-  In the below example image, we will give the input values in **Column B**.
- Then enter the given formula in the formula bar section.
- After that, it will show the result in the selected **Cell D3**.
- Here, we will also display the COUNTIF function result for your reference.
- The COUNTIF Function will count only 15 digits from a cell.

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

## Verdict:

In this tutorial, you can get some clarification on the **formulas for counting the long numbers in a cell without using the COUNTIF Function in Excel Office 365**. Hope that this article is useful to you. Don’t forget to drop your valuable feedback in the below comment section. 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 Also:

- **[Excel Formulas to Count the Cells that do not contain many Strings!!](https://geekexcel.com/wp-admin/post.php?post=16764&action=edit)**
- **[Formulas for Counting the Dates from a given Year in Excel!!](https://geekexcel.com/wp-admin/post.php?post=16783&action=edit)**