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" wrote:

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

--
__________________________________
HTH

Bob

"LiveUser" wrote in message
...
Thanks Bob.

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

"Bob Phillips" wrote:

=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" wrote in message
...
=COUNTIF(B$3:B3,B3)

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

Thank you.