count if, but not if
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.
|