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