How to Number Rows in Excel Using COUNTA Function
Another way you can number rows in Google Sheets is by using the COUNTA function.
For Example, you have to only number the rows that are filled.
Use this Formula:
=IF(ISBLANK(AB2),"",COUNTA($B$2:B2))
Follow the steps below to fill in the serial numbers
Step 1: Insert the formula in the A2 cell
Step 2: Position the Cursor in Cell A2 and drag the Plus Sign to Extend Sequence
Put the cursor at the bottom right of the cell A2 and drag the plus sign till which you want the numbering
Understand the formula
- In the formula “IF” function checks whether the adjacent cell is blank or not If it’s blank, the IF formula would return a blank and if it isn’t, it will count all the filled rows in the specified range and give that number.
- Here, We are using $B$2:B2 as the range where we have locked the first B2 (by having dollar sign before the column alphabet and row number) but not the second one.
- It allows us to expand the range when we copy it to other cells.
How to Number Rows in Google Sheets
Google Sheets has emerged as an indispensable tool for anyone looking to organize, analyze, and visualize their data efficiently. Knowing how to number rows in Google Sheets can significantly enhance your spreadsheet management skills.
In this article, we will be looking at how to number rows in Google Sheets.
How to Number Rows in Google Sheets
Contact Us