How can I count all the the 'zeros' from different cells such as A1, D1, G1, H1 TIA
A Anthony Slater Dec 21, 2005 #1 How can I count all the the 'zeros' from different cells such as A1, D1, G1, H1 TIA
B Bob Phillips Dec 21, 2005 #2 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)
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)
