L
LiveUser
=COUNTIF(B$3:B3,B3)
How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?
Thank you.
How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?
Thank you.
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike
=COUNTIF(B$3:B3,C3&"<>Inbound")
B
Bob Phillips
=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)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
L
LiveUser
Mike,
The formula did not work...
I tried a variation, but it did not work either.
=COUNTIF(B$3:B3,B3&C3"<>Inbound")
The formula did not work...
I tried a variation, but it did not work either.
=COUNTIF(B$3:B3,B3&C3"<>Inbound")
L
LiveUser
Thanks Bob.
Is there a way to make it so no number shows until "Outbound" is selected?
Is there a way to make it so no number shows until "Outbound" is selected?
B
Bob Phillips
Sorry mate, don't follow what you are asking here.
L
LiveUser
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
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
B
Bob Phillips
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)
=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)
L
LiveUser
Yes, Thank you.
Bob Phillips said: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)
S
SwearBear
Bob,
Can you tell me what the double dashes (--) mean?
Can you tell me what the double dashes (--) mean?
S
SwearBear
Bob,
Would you tell me please what the double dashes (--) mean?
Would you tell me please what the double dashes (--) mean?
T
T. Valko
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.