# Learn How to Count Cells Less Than Others In Microsoft Excel

Written by | 0 Comments | 634 Views

In this article, you will learn how to use the Microsoft Excel COUNT formula and its purpose in Microsoft Excel. You will also get to know how to count cells less than others and see the generic formula.

Count Cells Less than Using Microsoft Excel Count Formula

The main purpose of the Microsoft Excel COUNT formula is to count the number of cells that contain values less than a particular number. Here we will learn how to count cells less than other cells.  That implies, with the help of the COUNT formula you can able to count the number of cells that contain values less than a particular number. Here the COUNTIF function can be used. In the generic form of the formula, rng represents a range of cells that contain numbers, and X represents the threshold below which you want to count. So, with the help of the COUNT formula, you can able to count the number of cells that contain values less than a particular number.

General Syntax of the COUNT Cells Count Cells Less than Others

=COUNTIF(rng,"<X")

The Explanation for the Count Cells Less than Others

So we know that Microsoft Excel COUNT formula you can able to count the number of cells that contain values less than a particular number. Here we will learn how to count cells less than other cells. The COUNTIF function counts the number of cells in the range that contain numeric values less than X and returns the result in the form of the number.

It should be noted that If you want to use a value in another cell as part of the criteria, use the ampersand (&) character. So, with the help of the COUNT formula, you can able to count the number of cells that contain values less than a particular number.

|