Excel Formulas to Add Row Numbers and Skip Blanks ~ Simple Guide!!
Tags: excelformula, excelformulas
Published: 2021-07-12 03:22:26

---
title: Excel Formulas to Add Row Numbers and Skip Blanks ~ Simple Guide!!
published: true
date: 2021-07-07 10:19:46 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-add-row-numbers-and-skip-blanks-simple-guide/
---

In Excel, we can drag the fill handle to fill the sequence numbers in a column quickly and easily, but sometimes we need to number the rows based on adjacent cells. For example, if the cells contain value then number them, if there are blank cells, leave the sequence blank as well. How could you solve this job? Here we will show the simple tricks to **add the row numbers and skip the cells which are blanks in Excel**. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Add row numbers and skip blanks](https://geekexcel.com/wp-content/uploads/2021/07/Add-row-numbers-and-skip-blanks.png)](https://geekexcel.com/excel-formulas-to-add-row-numbers-and-skip-blanks-simple-guide/add-row-numbers-and-skip-blanks/#main)<figcaption id="caption-attachment-48660">Add row numbers and skip blanks</figcaption>

## Generic Formula:

- You can use the below formula to add sequential row numbers to a list of data and skip the cells that are blank in Excel.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)([ISBLANK](https://geekexcel.com/how-to-use-isblank-function-in-microsoft-excel-365/)(A1),””,[COUNTA](https://geekexcel.com/how-to-use-excel-counta-function-in-office-365-with-examples/)($A$1:A1))**

## Syntax Explanations:

- **IF** – In Excel, the [**IF function**](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/) helps to return one value for a TRUE result, and another for a FALSE result.
- **ISBLANK** – The [**ISBLANK function**](https://geekexcel.com/how-to-use-isblank-function-in-microsoft-excel-365/) will return TRUE when a cell contains is empty, and FALSE when a cell contains any text or not an empty case.
- **COUNTA** – This function counts the number of cells that are non-empty and returns the output in numbers. Read more on the **[COUNTA function](https://geekexcel.com/how-to-use-excel-counta-function-in-office-365-with-examples/)**.
- **A1** – It represents the input cell.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example image.

- First, we will enter the input values in **Column B.**
- Here we are going to add sequential row numbers to a list of data and skip the cells that are blank.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/07/Input-Ranges-26.png)<figcaption id="caption-attachment-48662">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/07/Enter-the-formula-25.png)<figcaption id="caption-attachment-48661">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/07/Result-26.png)<figcaption id="caption-attachment-48663">Result</figcaption>

## Verdict:

So yeah guys this is **how you can add the row numbers and skip the cells which are blanks in Excel**. Leave a **comment** or **reply** below to let me know what you think!

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Get the Profit Margin Percentage ~ Quickly!!](https://geekexcel.com/excel-formulas-to-get-the-profit-margin-percentage/)**
- **[How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)**
- **[Excel Formulas to Calculate the Surface Area of a Cone ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-surface-area-of-a-cone/)**
- **[Excel Formulas to Get the Percentage Discount ~ Useful Tricks!!](https://geekexcel.com/excel-formulas-to-get-the-percentage-discount/)**