Another COUNTIF question...

  • Thread starter Thread starter digitallifeform
  • Start date Start date
D

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:P,">0") - just counts both, and that's as
far as i have got.

Can anyone help me please.

Thanks
 
Hi

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

Arvi Laanemets
 
Back
Top