See this:

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

--
Biff
Microsoft Excel MVP


"SwearBear" wrote in message
...
Bob,

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


"Bob Phillips" wrote:

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" wrote in message
...
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.