With the function of = countif (c1:C9,0), you can count the cells in column C that are equal to zero. It's just that you have to choose your own data area. I just give you an example. The following 0 indicates that statistics will only be made when the cell value is equal to 0.