Count number of non-empty cells with value 0

formula
calc

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

ChameleonScales
15 ●5 ●12 ●15

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

robleyd

4295 ●3 ●12 ●33

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

Comments

Thank you!

ChameleonScales ( 2019-09-22 13:50:37 +0100 )edit

add a comment

Question Tools

1 follower

Stats

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

Seen: 200 times

Last updated: Sep 22 '19

Count number of non-empty cells with value 0 edit

1 Answer

Comments

Question Tools

Stats

Related questions

Count number of non-empty cells with value 0