CountIf

[carlin]

Is it possible to count the number of rows that a zero
appears in columns A2 and B2, A3 and B3...A100 and B100 ?

Thanks in advance.

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A100=0)*(B1:B100=0))