Nesting functions - Countif ...

[Dos Equis]

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 are:
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

 

[Bob Phillips]

=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]

Bob,

That works perfectly. Would you please explain what you did?

Thank you,

Byron

 

[Bob Phillips]

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]

Thank you very much. I think I know enough now to experiment with this
function and solve some of my other problems.

Byron