DAD,

as an aside, rather than NOT(ISERROR, I use ISNUMBER, makes it a tad more
readable

=SUMPRODUCT((ISNUMBER(FIND("Fr",A1:A10)))*(ISNUMBE R(FIND("B",A1:A10))))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Die_Another_Day" wrote in message
ups.com...
Nevermind, I was just making it too hard:
=SUMPRODUCT((NOT(ISERROR(FIND("Fr",A1:A10))))*(NOT (ISERROR(FIND("B",A1:A10)*
))))

Charles

Die_Another_Day wrote:
Bob Phillips, What a I missing to make this "SumProduct" formula work?

=SUMPRODUCT((NOT(ISERROR(FIND("Fr",A1:A10))))*(NOT (ISERROR(FIND("B",A1:A10))
)),(A1:A10))

Charles

Die_Another_Day wrote:

=SUM(IF(NOT(ISERROR(FIND("Fr",A1:A10))),IF(NOT(ISE RROR(FIND("B",A1:A10))),1)
))
then press Ctrl + Shift + Enter

Charles Chickering

HonorsOA wrote:
What formula counts how many cells contain two different criterias
i.e. if a
cell contains Fr as well as B I want it to count but not if it
contains one
or the other.