Counting texts in a cell

[lousydull]

I'm interested to count only "Mad" or "Mid" in a cell. Meaning either of the two are present will only count as one. Please can someone help to come up with a formula for excel? Example Cell A1 texts are: Mad, Mud, Mod, Med, Mid Result: Both "Mad" and "Mid" are present but will only count as 1


Mud, Mod, Med, Mid
Result: "Mad" is absent but "Mid" present thus, will count as 1


Mad, Mud, Mod, Med
Result: "Mad" is present but "Mid" absent thus, will count as 1


Mud, Mod, Med
Result: Both "Mad" and "Mid" are absent thus, will count as 0

 

[Peter_SSs]

If such data is possible, what count should it be for
a) Mad, Mud, Mod, Med, Mid, Mad, Mod, Mid, Mid
b) Old, Modern, Humid

 

[Peter_SSs]

.. otherwise try

Excel Workbook
	A	B
1	Mad, Mud, Mod, Med, Mid	1
2	Mud, Mod, Med, Mid	1
3	Mad, Mud, Mod, Med	1
4	Mud, Mod, Med	0
Count

If the text should not be case-sensitive then use SEARCH in place of FIND