How to Count Rows with Value in Google Sheets

Last Updated on April 13, 2023 by Jake Sheridan

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.