Another COUNTIF question...

[digitallifeform]

Hey all, i'm stuck.

I need to do a formula that will count the number of cells in column
'A' only if the corresponding cell in column 'B' has a value of '0'.

=COUNTIF(O:0,"0")+COUNTIF(P,">0") - just counts both, and that's as
far as i have got.

Can anyone help me please.

Thanks

 

[Arvi Laanemets]

Hi

=SUMPRODUCT((A1:A65536>0)*(B1:B65536<>"")*(B1:B65536=0))
(you can't use reference to column with SUMPRODUCT)

Arvi Laanemets