In this article, we will see the Formulas to Count the cells Contains Less than a Given Values in Excel Office 365 with its brief explanations and example. 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
General Formula:
- To count the number of cells that have values less than a given number in Excel, use the below formula.
=COUNTIF(range,”<X”)
Explanations for Syntax:
- COUNTIF – In Excel, COUNTIF Function will help to count the cells that match a single condition or criteria.
- Operator (<) – This operator symbol will count less than a particular value. If you count the cell which is less than or equal to the given value, use the (<=) symbol.
- Range – It represents input numbers given in the workbook.
- *X * – It is a value you want to be count.
- 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 screenshot, we entered the input ages in Column A.
- After that, apply the given formula in the formula bar section.
- Finally, it will show the result as shown below.
- Use the above steps, for counting the cells which contain less than a given number in Excel.
Conclusion:
From this article, you can know formulas to count the cells that contain values less than a given number in Excel Office 365 with a suitable example. Hope that this article is useful to you. If you have any queries , kindly drop it in the comment box. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!!
Top comments (0)