Written by Tijana Google Workplace / Sheets
Google Workplace is an online substitute for Microsoft’s Outlook, and it counts several different services - Docs, Slides, Sheets, Drive, and more.
Google Sheets is nearly the same as Microsoft’s Excel, allowing users to create an online shareable version of their sheets and files.
If you use Excel or Sheets on a daily basis, you’ve surely noticed that, at times, some of the cells and columns are blank and contain no data.
Having cells with no data can cause issues when doing calculations, and the best option would be to count all cells, except for the one that contains no information.
Luckily, Sheets has a function allowing just that - COUNTA. The COUNTA function is used for counting cells that contain data; however, when some of the cells contain special characters, you might run into issues.
If you’re unsure of how to use the COUNTA function and wish to organize your Sheets quickly, check out the step-by-step process below.
You might also like: How to Separate First and Last Name in Google Sheets.
The COUNTA function in Google Sheets counts the number of cells within a certain range that contain data - values, or a text string.
While using this function, the cells that do not contain any data are not taken into account.
Follow these steps to count the number of cells that contain data and are not blank in Google Sheets:
In the D12 empty string, the count function formula shows up, along with the number of empty cells in Google Sheets.
Note: The COUNTA function is the most commonly used one, and is the easiest method of counting cells that are blank and contain no data. However, in the case of using conditional formatting that makes the cell seem blank, even when it isn't, the calculations will not be correct. In such instances, it's recommended to use the SUMPRODUCT function.
Check out: How to Remove Gridlines in Google Sheets.
To avoid wrong calculations, use the SUMPRODUCT function. Follow these steps:
Google Sheets offers numerous functions which can help you organize your data easily, and make correct calculations that would normally take hours to finish if you do them manually.
In this article, we covered two different methods to count non-blank cells in Google Sheets.
If you liked this article, check out: How to Assign in Google Sheets and How to Combine First and Last Names in Google Sheets.
You might also find these articles interesting: