Counif with different cells, not a range
 

How can I count all the the 'zeros' from different cells such as A1, D1, G1, H1

TIA

Counif with different cells, not a range
 

Try this

=SUMPRODUCT(--(COUNTIF(OFFSET(1:1,0,{0,3,6,7},1,1),0)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Anthony Slater" wrote in message
...
How can I count all the the 'zeros' from different cells such as A1, D1,
G1, H1

TIA

Counif with different cells, not a range
 

Thanks Bob

That worked a treat...

Have a good Christmas

"Bob Phillips" wrote:

Try this

=SUMPRODUCT(--(COUNTIF(OFFSET(1:1,0,{0,3,6,7},1,1),0)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Anthony Slater" wrote in message
...
How can I count all the the 'zeros' from different cells such as A1, D1,
G1, H1

TIA