View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LiveUser LiveUser is offline
external usenet poster
 
Posts: 90
Default 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.