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 to the left and, karma permitting, upvote it. That will help other people with the same question.
Thank you!