count if, but not if

  • Thread starter Thread starter LiveUser
  • Start date Start date
L

LiveUser

=COUNTIF(B$3:B3,B3)

How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?

Thank you.
 
=IF(C3<>"Inbound",COUNTIF(B$3:B3,B3),"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Mike,

The formula did not work...

I tried a variation, but it did not work either.

=COUNTIF(B$3:B3,B3&C3"<>Inbound")
 
Thanks Bob.

Is there a way to make it so no number shows until "Outbound" is selected?
 
In C3 there is an option to choose Inbound or Outbound.

B C D
3 Orange
4 Apple Outbound 1
5 Orange Inbound
6 Orange Outbound 1
7 Orange Outbound 2
8 Apple Inbound
9 Grape
 
Is this what you mean?

=IF(AND(C3<>"Inbound",C3<>""),SUMPRODUCT(--($B$3:B3=B3),--($C$3:C3=C3)),"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Yes, Thank you.

Bob Phillips said:
Is this what you mean?

=IF(AND(C3<>"Inbound",C3<>""),SUMPRODUCT(--($B$3:B3=B3),--($C$3:C3=C3)),"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
Back
Top