Open Office Calc - Count the number of empty cells in a range

December 2016


This task can be achieve with the COUNTBLANK function (no need to count manually)

Syntax:
  • =COUNTBLANK(Range of cell)

In practice:
  • First select the cell on which the result will be displayed
  • Type:
  • =COUNTBLANK(using the mouse select the range of cell). press the Enter key.


Related :

This document entitled « Open Office Calc - Count the number of empty cells in a range » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.