Count Blank Non Empty Cells in Calc

This tutorial would show you how you can use some formula in Calc to count blank and non empty cells in LibreOffice Calc.

There are times, when you need to quickly find out how many cells are having text/numbers and how many cells are blank in a huge sheet with data. Here’s how you can do it.

Count blank cells

Use COUNTBLANK(range) function to calculate the blank cells. It returns the number of empty cells (i.e. not contains any text, numbers, even spaces) in the range.

Syntax

COUNTBLANK(Range)

Returns the number of empty cells in the cell range Range.

In below example, there are 5 blank cells (yellow highlighted) in the range A1 to A10 and COUNTBLANK(A1:A10) returns 5.

SEE ALSO:  Maximum Number of Rows, Columns, Cells in LibreOffice Calc
COUNTBLANK Example
COUNTBLANK Example

Count non empty cells

Use COUNTA(range) function to count the cells those are not blank or empty. It counts the cells that having some values – texts, numbers.

Syntax

COUNTA(Range)

Returns the number of cells that having texts, numbers.

In below example, COUNTA(A1:A10) returns 5 as there are five values present.

COUNTA - Demo
COUNTA – Demo

This way you can count the blank and non empty cells in LibreOffice Calc.

Official Reference

 

Drop a comment below with comments, questions. If you like this tutorial, don’t forget to subscribe for article updates using the subscribe box below.

 


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Join our Telegram channel and stay informed on the move.

Related


arindam

IT professional by profession and founder of libreofficehelp.com. Loving Linux and other technologies since 2002. I believe in open source and its philosophy. Follow me on Twitter or email me.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.