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

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

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

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

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