Average number of a specific number in group

Basically I have a table that consists of numbers that grows daily- C2-AG2. as the month progresses they fill up right to left with numbers. In AI2, I would like to figure out how many of those cells = "0"

Trickshot may also be, I would like to make sure the formula omits anything that is blank entirely.

for instance if the cells read like:

10|0|9|80|0|_|_|_|

The formula should figure out that 2 out of 5 are "0", and therefor 40%

Thanks in advance!

Try

=COUNTIF(C2:AG2,0)

and to figure out percentage..

=COUNTIF(C2:AG2,0)/COUNT(C2:AG2)

NBVC said:

Try

=COUNTIF(C2:AG2,0)

and to figure out percentage..

=COUNTIF(C2:AG2,0)/COUNT(C2:AG2)

Click to expand...

Brilliant! worked perfectly- THANK YOU!