FORMULAS
Sweet! Thanks, I thought I had to use ISERROR to keep the formula from
returning an error. This is going to save me alot of negating.
Thanks again,
Charles
Bob Phillips wrote:
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.
|