How to find Excel Range contains numbers in Excel 365?
Tags: excelformula, excelformulas
Published: 2021-10-25 12:41:46

---
title: How to find Excel Range contains numbers in Excel 365?
published: true
date: 2021-10-23 17:27:13 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/how-to-find-excel-range-contains-numbers-in-excel-365/
---

To calculate a range of values is easy for most Excel users, but have you ever tried to find the range that contains numbers in a specific cell? Here we will show the formulas to  **find the Excel range containing numbers in Excel 365**. Let’s dive 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)

## Generic Formula

- If you want to find the **range containing numbers** , you can use the below formula.

```
=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(--[ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)(range))>0

```

## 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 return the result as the sum of the products.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **ISNUMBER** – The **[ISNUMBER function](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)** returns TRUE when a cell contains a number, and FALSE if there will not be a number.
- **Range**  – It represents the input range.
- **Minus Operator (-)** – This symbol will help to subtract any two values.

## Practical Example

- First, you need to **enter the input values** in  **Column B** ,  **Column**   **C, ** and ** Column D**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Sample-data-43.png)

- Then, you have to find out the **range containing numbers**.
- Now, you need to **select the cell range B5:B9**.
- After that, you have to type the below-given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(--[ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)(B5:B9))>0

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Use-the-formula-3.png)<figcaption>Use the formula</figcaption>

- You need to press the **ENTER key** and the **result** will get updated in the **cell G5**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Output-42.png)<figcaption>Output</figcaption>

- Then, you have to **select the cell range C5:C9** and type the below-given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(--[ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)(C5:C9))>0

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Ex-1-Use-the-formula.png)<figcaption>Use the formula</figcaption>

- Now, you need to press the **ENTER key** and the **result** will get updated in the **cell G6**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Ex-1-Output.png)<figcaption>Output</figcaption>

- After that, you have to **select the cell range D5:D9** and type the below-given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(--[ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)(D5:D9))>0

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Ex-2-Use-the-formula-1.png)<figcaption>Use the formula</figcaption>

- Finally, you need to press the **ENTER key** and the **result** will get updated in the **cell G7**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Ex-2-Output-1.png)<figcaption>Output</figcaption>

## Verdict

Here we have explained the formulas to **find the Excel range containing numbers in Excel 365**. Let me know if you have any  **doubts**  regarding this article or any other article on this site.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Further Reference:**

- **[Excel Formulas to Convert Numbers into Text ~ A Complete Guide!!](https://geekexcel.com/excel-formulas-to-covert-numbers-into-text-a-complete-guide/)**
- **[Excel Formulas to Calculate the Average of Numbers!!](https://geekexcel.com/excel-formulas-to-calculate-the-average-of-numbers/)**
- **[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/)**
- **[Excel Formulas to Sum the Values Between two Numbers!!](https://geekexcel.com/excel-formulas-to-sum-the-values-between-two-numbers/)**