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

October 2017


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.

Published by jak58. Latest update on May 11, 2011 at 02:19 PM by jak58.
This document, titled "Open Office Calc - Count the number of empty cells in a range," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).