Ask Your Question

Count number of non-empty cells with value 0

asked 2019-09-22 05:41:58 +0100

ChameleonScales gravatar image

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 ?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-09-22 06:37:57 +0100

robleyd gravatar image

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.

edit flag offensive delete link more


Thank you!

ChameleonScales gravatar imageChameleonScales ( 2019-09-22 13:50:37 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-22 05:41:58 +0100

Seen: 200 times

Last updated: Sep 22 '19