# How to Count Rows with Value in Google Sheets

In this tutorial, you will learn how to count rows with values in Google Sheets

## How to Count Rows with Value in Google Sheets

If you want to determine how many rows in your dataset contains values, then you can use a combination of formulas in Google Sheets.

Using either the COUNTA, COUNTIF, and SUMPRODUCT functions, you can easily count the number of non-blank rows in your spreadsheet.

This is especially useful when you’re dealing with large datasets and you want to quickly assess how many rows in your dataset are non-empty.

In this guide, we will show you how to count the number of rows with a value in Google Sheets using COUNTA, COUNTIF, and SUMPRODUCT.

## How to Count Non-Empty Rows in Google Sheets

Here’s how to count the number of non-empty rows in a Google Sheets spreadsheet.

### Step 1

First, select an empty cell where you want to place the count of non-empty rows.

### Step 2

Next, type the COUNTA function.

### Step 3

Add the column you want to use to count the rows with values as an argument.

In this example, we’ve found that there are a total of 15 rows with values in our dataset.

### Step 4

We can specify a specific range to avoid counting the column header values.

### Step 5

We can also use the COUNTIF function to achieve a similar result. We’ll simply need to use the argument “<>” as a criteria for the formula.

### Step 6

We can also use the SUMPRODUCT and LEN functions together to determine the number of cells in a range have actual values. The LEN function is used to check the number of characters present in the cell.

## Summary

This guide should be everything you need to count rows with values in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.