Average number of a specific number in group

pocchr1919

New member
Joined
Sep 12, 2014
Messages
2
Reaction score
0
Points
0
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!
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try

=COUNTIF(C2:AG2,0)

and to figure out percentage..

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