In this tutorial, we will guide you to know the simple formulas to calculate total rows in range in Excel Office 365 with basic examples and syntax. Let’s step into this article and learn the formulas!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula
- If you want to calculate total rows in a range, you can use the below formula.
=[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(rng)
Syntax Explanation
- ROWS – This function will return the count of rows in a given reference. Read more on the ROWS function.
- *Rng * – It represents the input range.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example
- For instances, you have to create a sample data in Microsoft Excel.
- To count the total number of rows in range , you need to use the below given formula in the formula bar.
=[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(B5:B10)
- Finally, you will get the result for the range B5:C10 in rows as given below.
Verdict
From this bride tutorial, we have learned the formula to calculate total rows in range in Excel Office 365 with practical examples. Go for it. If you have any doubts, feel free to share them with us. Thank you!! To learn more about Excel, just click here: **Geek Excel!! **Keep Learning with us!!
Read Also:
Top comments (0)