column a data is to be entered manually. If you make regular input, you can use drag to fill it faster.

the function =COUNTIF(C1:C9,) can be used to count the cells equal to zero in column C .. It's just that you have to choose your own data area. I'm just giving you an example. The following means that statistics will only be made when the cell value is equal to .