Formula Reeating Values

[ststern45]

Hi everyone,

Need a formula that will count how many zeroes appear in a cell range.

Fro example,

Cell Range A1 through D1 all equal 0 Cell E1 = 1
Total will be 4

Cell Range A1 J1 all equal 0 Cell K1 = 3
Total will be 10

Range is A1 through N1

I have the following formula below but will not count consecutive zeroes at 10

=IFERROR(IF(COUNTIF($A1:$N1,"<=0")=COLUMNS($A1:$N1),COLUMNS($A1:$N1),MATCH(TRUE,INDEX(>=0,0),0)-1),0)

Thanks in advance!!

 

[Chrisdontm]

Is this what you are looking for...?

=COUNTIF($A$1:$N$1,0)