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 ?

Try =COUNTIF(A1:A10,0) - it seems to do what you want.

If this answer helped you, please accept it by clicking the check mark :heavy_check_mark: to the left and, karma permitting, upvote it. That will help other people with the same question.

Thank you!