View original (French)

Non-blank cell criteria

Solved
terisa -  
tontong Posted messages 2575 Registration date   Status Member Last intervention   -
Hello,

I am using OpenOffice Calc.

I would like to count the number of non-empty cells in a column. I haven't worked on a spreadsheet in a long time, but I thought of using the COUNTIF function by selecting the column as the data range.

Now I need to enter the criterion: we consider the cell "if it is not empty" (or "if it contains a string or if it contains a number"), but I don't know how to express this in the formula.

How can I set this criterion "if the cell is non-empty" in the cell?

Thank you

2 answers

  1.
    chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
     
    Hello,

    in Excel you can use the function COUNTA().
    Let's see if it exists (or an equivalent) in OpenOffice.

    Best regards.
    --
    That guy wasn't very bright, because he was foolish.
    2
  2. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    Hello,
    Yes, NBVAL exists and meets the need.
    However, be careful, a cell that contains a formula is not considered empty, even if the formula returns an empty text value "".
    0