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
|