Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula: 2nd column qualifier
In column C, I have a lead source, ie Bid, Yellow Pages, Website etc. In
column G, I have Sold, Open, Lost. I have tried to come up with a nestled function that counts the instances of sold in column G for each source in C, but with no luck. Any help? thanks much, Andy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula: 2nd column qualifier
=SUMPRODUCT(--(C2:C200="Bid"),--(G2:G200="Sold"))
etc. Note, SUMPRODUCT uses explicit ranges, not whole columns. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AJB" wrote in message ... In column C, I have a lead source, ie Bid, Yellow Pages, Website etc. In column G, I have Sold, Open, Lost. I have tried to come up with a nestled function that counts the instances of sold in column G for each source in C, but with no luck. Any help? thanks much, Andy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula: 2nd column qualifier
I am trying to return a count, and this formula gives me true/false.
To add more info, I am making a summary table for the years sales and want to know our closing percentage for each type. I'm not to sure how to describe this differently. "Bob Phillips" wrote: =SUMPRODUCT(--(C2:C200="Bid"),--(G2:G200="Sold")) etc. Note, SUMPRODUCT uses explicit ranges, not whole columns. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AJB" wrote in message ... In column C, I have a lead source, ie Bid, Yellow Pages, Website etc. In column G, I have Sold, Open, Lost. I have tried to come up with a nestled function that counts the instances of sold in column G for each source in C, but with no luck. Any help? thanks much, Andy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula: 2nd column qualifier
No, it gives you a count as you asked for.
Try it and then tell me it doesn't do what you want. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AJB" wrote in message ... I am trying to return a count, and this formula gives me true/false. To add more info, I am making a summary table for the years sales and want to know our closing percentage for each type. I'm not to sure how to describe this differently. "Bob Phillips" wrote: =SUMPRODUCT(--(C2:C200="Bid"),--(G2:G200="Sold")) etc. Note, SUMPRODUCT uses explicit ranges, not whole columns. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AJB" wrote in message ... In column C, I have a lead source, ie Bid, Yellow Pages, Website etc. In column G, I have Sold, Open, Lost. I have tried to come up with a nestled function that counts the instances of sold in column G for each source in C, but with no luck. Any help? thanks much, Andy |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula: 2nd column qualifier
Bob-
I tried formatting each column to be text, thinking that might be altering the results. That did not change anything. The formula result still goes between true and false, depending on how I alter the vertical range. I'm thinking that intermittent numbers in column G between monthly data sets may be goofing it up. I will try to reset and post back. thanks, Andy "Bob Phillips" wrote: No, it gives you a count as you asked for. Try it and then tell me it doesn't do what you want. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AJB" wrote in message ... I am trying to return a count, and this formula gives me true/false. To add more info, I am making a summary table for the years sales and want to know our closing percentage for each type. I'm not to sure how to describe this differently. "Bob Phillips" wrote: =SUMPRODUCT(--(C2:C200="Bid"),--(G2:G200="Sold")) etc. Note, SUMPRODUCT uses explicit ranges, not whole columns. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AJB" wrote in message ... In column C, I have a lead source, ie Bid, Yellow Pages, Website etc. In column G, I have Sold, Open, Lost. I have tried to come up with a nestled function that counts the instances of sold in column G for each source in C, but with no luck. Any help? thanks much, Andy |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula: 2nd column qualifier
I moved the monthly numeric data sets from G and it worked. Thanks for your
help Bob. Andy "AJB" wrote: Bob- I tried formatting each column to be text, thinking that might be altering the results. That did not change anything. The formula result still goes between true and false, depending on how I alter the vertical range. I'm thinking that intermittent numbers in column G between monthly data sets may be goofing it up. I will try to reset and post back. thanks, Andy "Bob Phillips" wrote: No, it gives you a count as you asked for. Try it and then tell me it doesn't do what you want. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AJB" wrote in message ... I am trying to return a count, and this formula gives me true/false. To add more info, I am making a summary table for the years sales and want to know our closing percentage for each type. I'm not to sure how to describe this differently. "Bob Phillips" wrote: =SUMPRODUCT(--(C2:C200="Bid"),--(G2:G200="Sold")) etc. Note, SUMPRODUCT uses explicit ranges, not whole columns. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AJB" wrote in message ... In column C, I have a lead source, ie Bid, Yellow Pages, Website etc. In column G, I have Sold, Open, Lost. I have tried to come up with a nestled function that counts the instances of sold in column G for each source in C, but with no luck. Any help? thanks much, Andy |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif formula: 2nd column qualifier
That really should not have caused a problem, they should just not get
counted. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AJB" wrote in message ... I moved the monthly numeric data sets from G and it worked. Thanks for your help Bob. Andy "AJB" wrote: Bob- I tried formatting each column to be text, thinking that might be altering the results. That did not change anything. The formula result still goes between true and false, depending on how I alter the vertical range. I'm thinking that intermittent numbers in column G between monthly data sets may be goofing it up. I will try to reset and post back. thanks, Andy "Bob Phillips" wrote: No, it gives you a count as you asked for. Try it and then tell me it doesn't do what you want. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AJB" wrote in message ... I am trying to return a count, and this formula gives me true/false. To add more info, I am making a summary table for the years sales and want to know our closing percentage for each type. I'm not to sure how to describe this differently. "Bob Phillips" wrote: =SUMPRODUCT(--(C2:C200="Bid"),--(G2:G200="Sold")) etc. Note, SUMPRODUCT uses explicit ranges, not whole columns. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AJB" wrote in message ... In column C, I have a lead source, ie Bid, Yellow Pages, Website etc. In column G, I have Sold, Open, Lost. I have tried to come up with a nestled function that counts the instances of sold in column G for each source in C, but with no luck. Any help? thanks much, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invalid qualifier error in macro | Excel Discussion (Misc queries) | |||
COUNTIF formula with several variables in 1 column | Excel Discussion (Misc queries) | |||
Add qualifier to andif statement | New Users to Excel | |||
setting text qualifier in Excel | Excel Discussion (Misc queries) | |||
IF function using a dates as the qualifier.. | Excel Worksheet Functions |