Excel Formulas for Counting Cells that Contain Odd Numbers!!
Tags: excelformula, excelformulas
Published: 2020-10-31 12:17:20

---
title: Excel Formulas for Counting Cells that Contain Odd Numbers!!
published: true
date: 2020-10-31 12:04:09 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-for-counting-cells-that-contain-odd-numbers/
---

In this article, we will guide you to learn the **Formulas for counting the number of cells that contain odd numbers in Excel** with its basic syntax and explanations. 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 cells that contain odd numbers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Formulas-to-count-cells-that-contain-odd-numbers.png)](https://geekexcel.com/excel-formulas-for-counting-cells-that-contain-odd-numbers/formulas-to-count-cells-that-contain-odd-numbers/#main)<figcaption id="caption-attachment-16646">Formulas to count cells that contain odd numbers</figcaption>
## General Formula:

- To count the number of cells that have odd numbers in Excel, use the below formula.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(–([MOD](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)(Range,2)=1))**

## Syntax Explanations:

- **SUMPRODUCT** – In Excel, this function will help to multiply the corresponding array or range and returns the sum of the products. Read more on the[**SUMPRODUCT Function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/).
- **MOD** – The **[MOD Function](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)** is used to return the remainder of the two numbers after division.
- **Minus operator (-)** – This symbol helps to subtract two numbers or arrays.
- **Range** -It represents an input range given in a worksheet.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- In the below image, we will give the input in **Column B**.
- Then, enter the given formula in the selected area.
- After applying the formula, it will show the output as given in the below image.

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

## Verdict:

From this tutorial, you can get to know the **Formulas to count the number of cells that have any odd numbers in Excel Office 365** with a suitable example. Hope that this article is useful to you. Kindly, drop your **feedback** in the below 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 More On:

- [**Formulas for Counting Cells that Begin with Some Value in Excel!!**](https://geekexcel.com/wp-admin/post.php?post=16515&action=edit)
- **[Formulas for counting the cells that contain Errors in Excel Office 365!!](https://geekexcel.com/wp-admin/post.php?post=16545&action=edit)**