Count number of non-empty cells with value 0
In Calc, when I count cells that have a value of 0 with SUMPRODUCT(A1:A10=0)
, the result also includes empty cells.
Is there a formula to only take into account the cells that aren't empty ?