How am I able to count the cells which contain only 0
My range is
| July Payment | August Payment | September Payment | October Payment | December Payment |
|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 1000 |
I tried to use:
=COUNTIF(F2:K2,0)
which then returns 5 as all cells contain a 0.
However, I only want it to return the number which ARE 0. I have tried the conditional formatting for cells that equal 0 but doesn’t return anything. In this scenario, it should be returning 4 not 5.
1