how many cell in a row that contain certain combination from a larger combination

Hi. actually I found a solution for your problem and its formula is too long. Bu ACE_XL has already figured it out. But I want to present you my formula. Feel a little uncomfortable to come with such a long formula
=IF(IF(SUM(IF(ISNUMBER(MATCH(TRIM(MID(LEFT($E$1,FIND(" ",$E$1,1))&$E$1,FIND(" ",LEFT($E$1,FIND(" ",$E$1,1))&$E$1,ROW(INDIRECT("1:"&LEN(LEFT($E$1,FIND(" ",$E$1,1))&A1)))),3))+0,TRIM(MID(LEFT(A1,FIND(" ",A1,1))&A1,FIND(" ",LEFT(A1,FIND(" ",A1,1))&A1,ROW(INDIRECT("1:"&LEN(LEFT(A1,FIND(" ",A1,1))&A1)))),3))+0,0)),1,0))=0,0,SUM(IF(ISNUMBER(MATCH(TRIM(MID(LEFT($E$1,FIND(" ",$E$1,1))&$E$1,FIND(" ",LEFT($E$1,FIND(" ",$E$1,1))&$E$1,ROW(INDIRECT("1:"&LEN(LEFT($E$1,FIND(" ",$E$1,1))&A1)))),3))+0,TRIM(MID(LEFT(A1,FIND(" ",A1,1))&A1,FIND(" ",LEFT(A1,FIND(" ",A1,1))&A1,ROW(INDIRECT("1:"&LEN(LEFT(A1,FIND(" ",A1,1))&A1)))),3))+0,0)),1,0)))=IF(SUM(IF(ISNUMBER(TRIM(MID(LEFT($E$1,FIND(" ",$E$1,1))&$E$1,FIND(" ",LEFT($E$1,FIND(" ",$E$1,1))&$E$1,ROW(INDIRECT("1:"&LEN(LEFT($E$1,FIND(" ",$E$1,1))&A1)))),3))+0),1,0))=0,99,SUM(IF(ISNUMBER(TRIM(MID(LEFT($E$1,FIND(" ",$E$1,1))&$E$1,FIND(" ",LEFT($E$1,FIND(" ",$E$1,1))&$E$1,ROW(INDIRECT("1:"&LEN(LEFT($E$1,FIND(" ",$E$1,1))&A1)))),3))+0),1,0))),1,0)