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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Hi

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

Arvi Laanemets


"digitallifeform" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> 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
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>