Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if, but not if
=COUNTIF(B$3:B3,B3)
How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"? Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if, but not if
=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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if, but not if
=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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if, but not if
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if, but not if
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if, but not if
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if, but not if
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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if, but not if
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" 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. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if, but not if
Bob,
Would you tell me please 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" 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. |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if, but not if
See this:
http://xldynamic.com/source/xld.SUMPRODUCT.html -- Biff Microsoft Excel MVP "SwearBear" wrote in message ... 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" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |