ROWS function is used to get the total count of rows in an array or in cells range in an excel worksheet.
ROWS Function has only one argument i.e. array, where we need to give cell range or array
=ROWS(array)
array argument is used to give the cell range for which total count of rows are required
The ROW function in Excel is very simple and easy to use. Let us understand the working of ROW in Excel Example:
Here we have some examples, where:
We will be using ROWS function as follows:
Hope you learned this Function,
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe to us or follow us on Social Media by clicking the below buttons:
VBA Code to Count Color Cells With Conditional Formatting Have you ever got into situation in office where you need to count the cells with specific color in conditional formatted Excel sheet? If yes then…
An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.
INT function is used to round down the numeric value to nearest integer. INT Function has one required argument i.e. number.
LOWER function is used for changing the format of any text or string to LOWER case.
SUBSTITUTE function is used to substitute the existing old text to new text.
Microsoft Excel “HOUR, MINUTE, SECOND Functions” are time related functions helps to extract the Hour, Minute or Second from a complete Time.