| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting functions - Countif ...
Hi,
I'm trying to build a function which counts the number of subscribers in a list by carrier. Column A has the carriers listed, Column O is either "Yes" or blank If "Yes", then that address is on the Do Not Deliver list and the entry should be excluded.I'd have thought I should write a function that looked like: =COUNTIF(A:A, Carrier) AND (O:O, " ") That dosen't work nor does it work with enclosing parentheses. My carriers a Angeline Bruce Gina Terry I can produce a count of their names, but since some of the entries are DND's I end up with false results. I've looked through three books and found out that it's not addressed in any of them. Any help would be wonderful. Thanks, Byron |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting functions - Countif ...
=SUMPRODUCT(--($A$1:$A$100="Angeline"),--($O$1:$O$100=""))
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dos Equis" wrote in message oups.com... Hi, I'm trying to build a function which counts the number of subscribers in a list by carrier. Column A has the carriers listed, Column O is either "Yes" or blank If "Yes", then that address is on the Do Not Deliver list and the entry should be excluded.I'd have thought I should write a function that looked like: =COUNTIF(A:A, Carrier) AND (O:O, " ") That dosen't work nor does it work with enclosing parentheses. My carriers a Angeline Bruce Gina Terry I can produce a count of their names, but since some of the entries are DND's I end up with false results. I've looked through three books and found out that it's not addressed in any of them. Any help would be wonderful. Thanks, Byron |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting functions - Countif ...
Bob,
That works perfectly. Would you please explain what you did? Thank you, Byron Bob Phillips wrote: =SUMPRODUCT(--($A$1:$A$100="Angeline"),--($O$1:$O$100="")) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dos Equis" wrote in message oups.com... Hi, I'm trying to build a function which counts the number of subscribers in a list by carrier. Column A has the carriers listed, Column O is either "Yes" or blank If "Yes", then that address is on the Do Not Deliver list and the entry should be excluded.I'd have thought I should write a function that looked like: =COUNTIF(A:A, Carrier) AND (O:O, " ") That dosen't work nor does it work with enclosing parentheses. My carriers a Angeline Bruce Gina Terry I can produce a count of their names, but since some of the entries are DND's I end up with false results. I've looked through three books and found out that it's not addressed in any of them. Any help would be wonderful. Thanks, Byron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting functions - Countif ...
All explained at http://www.xldynamic.com/source/xld.SUMPRODUCT.html.
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dos Equis" wrote in message oups.com... Bob, That works perfectly. Would you please explain what you did? Thank you, Byron Bob Phillips wrote: =SUMPRODUCT(--($A$1:$A$100="Angeline"),--($O$1:$O$100="")) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dos Equis" wrote in message oups.com... Hi, I'm trying to build a function which counts the number of subscribers in a list by carrier. Column A has the carriers listed, Column O is either "Yes" or blank If "Yes", then that address is on the Do Not Deliver list and the entry should be excluded.I'd have thought I should write a function that looked like: =COUNTIF(A:A, Carrier) AND (O:O, " ") That dosen't work nor does it work with enclosing parentheses. My carriers a Angeline Bruce Gina Terry I can produce a count of their names, but since some of the entries are DND's I end up with false results. I've looked through three books and found out that it's not addressed in any of them. Any help would be wonderful. Thanks, Byron |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting functions - Countif ...
Thank you very much. I think I know enough now to experiment with this
function and solve some of my other problems. Byron Bob Phillips wrote: All explained at http://www.xldynamic.com/source/xld.SUMPRODUCT.html. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dos Equis" wrote in message oups.com... Bob, That works perfectly. Would you please explain what you did? Thank you, Byron Bob Phillips wrote: =SUMPRODUCT(--($A$1:$A$100="Angeline"),--($O$1:$O$100="")) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dos Equis" wrote in message oups.com... Hi, I'm trying to build a function which counts the number of subscribers in a list by carrier. Column A has the carriers listed, Column O is either "Yes" or blank If "Yes", then that address is on the Do Not Deliver list and the entry should be excluded.I'd have thought I should write a function that looked like: =COUNTIF(A:A, Carrier) AND (O:O, " ") That dosen't work nor does it work with enclosing parentheses. My carriers a Angeline Bruce Gina Terry I can produce a count of their names, but since some of the entries are DND's I end up with false results. I've looked through three books and found out that it's not addressed in any of them. Any help would be wonderful. Thanks, Byron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining LOOKUP and COUNTIF functions | Excel Worksheet Functions | |||
| Combining COUNTIF and AND functions | Excel Worksheet Functions | |||
| nesting with countif | Excel Discussion (Misc queries) | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
| nesting 18 x functions | Excel Worksheet Functions | |||
Linear Mode
