count if, but not if

's Computer Specifications

=COUNTIF(B$3:B3,B3)

How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?

Thank you.

's Computer Specifications

=COUNTIF(B$3:B3,C3&"<>Inbound")

"LiveUser" wrote:

> =COUNTIF(B$3:B3,B3)
>
> How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?
>
> Thank you.

's Computer Specifications

=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" <(E-Mail Removed)> wrote in message
news:4201988E-DED7-4A78-90E2-(E-Mail Removed)...
> =COUNTIF(B$3:B3,B3)
>
> How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?
>
> Thank you.

's Computer Specifications

Mike,

The formula did not work...

I tried a variation, but it did not work either.

=COUNTIF(B$3:B3,B3&C3"<>Inbound")

"Mike" wrote:

> =COUNTIF(B$3:B3,C3&"<>Inbound")
>
> "LiveUser" wrote:
>
> > =COUNTIF(B$3:B3,B3)
> >
> > How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?
> >
> > Thank you.

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:4201988E-DED7-4A78-90E2-(E-Mail Removed)...
> > =COUNTIF(B$3:B3,B3)
> >
> > How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?
> >
> > Thank you.
>
>
>

's Computer Specifications

Sorry mate, don't follow what you are asking here.

--
__________________________________
HTH

Bob

"LiveUser" <(E-Mail Removed)> wrote in message
news:1C074593-7F93-46CB-868C-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:4201988E-DED7-4A78-90E2-(E-Mail Removed)...
>> > =COUNTIF(B$3:B3,B3)
>> >
>> > How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?
>> >
>> > Thank you.
>>
>>
>>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:1C074593-7F93-46CB-868C-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:4201988E-DED7-4A78-90E2-(E-Mail Removed)...
> >> > =COUNTIF(B$3:B3,B3)
> >> >
> >> > How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?
> >> >
> >> > Thank you.
> >>
> >>
> >>
>
>
>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:BDCBE0C3-5944-497D-894D-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:1C074593-7F93-46CB-868C-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
>> >> news:4201988E-DED7-4A78-90E2-(E-Mail Removed)...
>> >> > =COUNTIF(B$3:B3,B3)
>> >> >
>> >> > How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?
>> >> >
>> >> > Thank you.
>> >>
>> >>
>> >>
>>
>>
>>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:BDCBE0C3-5944-497D-894D-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:1C074593-7F93-46CB-868C-(E-Mail Removed)...
> >> > 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" <(E-Mail Removed)> wrote in message
> >> >> news:4201988E-DED7-4A78-90E2-(E-Mail Removed)...
> >> >> > =COUNTIF(B$3:B3,B3)
> >> >> >
> >> >> > How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?
> >> >> >
> >> >> > Thank you.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:BDCBE0C3-5944-497D-894D-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:1C074593-7F93-46CB-868C-(E-Mail Removed)...
> >> > 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" <(E-Mail Removed)> wrote in message
> >> >> news:4201988E-DED7-4A78-90E2-(E-Mail Removed)...
> >> >> > =COUNTIF(B$3:B3,B3)
> >> >> >
> >> >> > How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"?
> >> >> >
> >> >> > Thank you.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count duplicats, display incremental count, restart count at changein value	JenIT	Microsoft Excel Programming	2	24th Aug 2010 09:10 PM
Count unique field1 combined with count field2, both grouped andungrouped	john.mctigue@health.wa.gov.au	Microsoft Access Queries	3	19th Dec 2008 03:52 AM
Count Employee Work Time - Don't Double-count Overlapping Apts.	=?Utf-8?B?Sg==?=	Microsoft Excel Worksheet Functions	0	27th Apr 2007 05:52 AM
how to get count(col1), count(col2), count(sol3) with only one query	Mario Krsnic	Microsoft Access Queries	2	27th Oct 2006 06:52 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row	Sam via OfficeKB.com	Microsoft Excel Worksheet Functions	9	31st Jul 2005 03:37 AM