count if, but not if
Yes, Thank you.
"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.
|