count if, but not if

[LiveUser]

=COUNTIF(B$3:B3,B3)

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

Thank you.

 

[Mike]

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

 

[Bob Phillips]

=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)

 

[LiveUser]

Mike,

The formula did not work...

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

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

 

[LiveUser]

Thanks Bob.

Is there a way to make it so no number shows until "Outbound" is selected?

 

[Bob Phillips]

Sorry mate, don't follow what you are asking here.

 

[LiveUser]

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

 

[Bob Phillips]

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)

 

[LiveUser]

Yes, Thank you.

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)

 

[SwearBear]

Bob,

Can you tell me what the double dashes (--) mean?

 

[SwearBear]

Bob,

Would you tell me please what the double dashes (--) mean?

 

[T. Valko]

See this:

http://xldynamic.com/source/xld.SUMPRODUCT.html