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
 
This is probably a cheats way of doing it but...

I would create a third column with this formula:

=if(B1=0,A1,"")

then at the bottom of the third column, put:

=countif(A1:A100) - if you have 100 cells that is.

or you could hide the third column, and put the above
countif formula at the bottom of the first or second
column.

Hope that helps,

AJ
 
Since you're not designating anything in or for Column A, try:
=COUNTIF(B:B,0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

message 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
 
try this. Modify to suit. Cannot use entire column.
=SUMPRODUCT((B2:B8=0)*(LEN(B2:B8)>0)*(A2:A8<>""))
 
Back
Top