Count Blank Non Empty Cells in Calc

15245 views
2

This tutorial will show you how to use formulas in Calc to count blank and non-empty cells in LibreOffice Calc.

Sometimes you need to quickly find out how many cells have 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 containing any text, numbers, or even spaces) in the range.

Syntax

=COUNTBLANK(Range)

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

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

COUNTBLANK Example
COUNTBLANK Example

Count non-empty cells

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

Syntax

COUNTA(Range)

Returns the number of cells that have texts and numbers.

In the below example, COUNTA(A1:A10) returns five 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 and questions.

Join our Telegram channel and stay informed on the move.

arindam

Creator of libreofficehelp.com. The aim is to help as many people as possible with easy-to-understand tutorials. Connect with me via Telegram, Twitter, LinkedIn, or send us an email.

Subscribe
Notify of
guest

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

2 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Fergus Pearson

Can I use COUNTA and COUNTBLANK somehow to count merged cells as if they were single cells?

Dave

Care to explain why you at LibreOffice have to be such special unique snowflakes and make it differently than in OpenOffice.
Why is there no difference between COUNTIF([range];””) and COUNTBLANK([range]?? Why do you need useless doubled function?

Last edited 3 months ago by Dave