Count cells for specific combination of words and not singular words

[JABWootton]

I am trying to count cells for specific combination of words and not singular words

For example:
In Cell A1 I have the word Cat
In Cell B1 I have the word Cat & Dog

What formula can be used to count the occurrences of the words Cat & Dog in a cell but not just the word Cat?

The answer for the above example would be 1 (Cat & Dog)

Thanks

 

[BobColorado]

I am currently on an older version of Excel 2016 and not 365 which I plan to move to soon?
thank you for detailing the formulas add the two parts to get the current desired result.
I will take a look at F9 or Evaluate Formula soon.
At first when I failed to get results with your formula, I carefully reviewed each character to find out I was not typing exactly what you shared, but as you say my example of Excel's fix to my issue it added the extras?
THANK YOU for you time, talents in adding me with this.

Bob

 

[jtakw]

You're welcome.

I'm using 2016 also, now that you got the formula accepted and working by Excel, may be try removing the extra brackets and see if it'll work, again they don't hurt the formula, but I know for a fact it's not needed. (I don't believe it may have anything to do with regional settings, but I can't be sure)

 

[jtakw]

In L75 is the COUNTIF without SUM, it's just manually adding the 2 different counts together:

Book3.xlsx
	L
64	HP color
65	Lexmark color
66	Xerox Color
67	Xerox Color
68	Xerox model 1234 Color
69	Color Xerox
70	Xerox 37593 model Color
71	Color 12345 model Xerox
72	Xerow 12345
73
74	6
75	6
Sheet821

Cell Formulas
Range	Formula
L74	L74	=SUM(COUNTIF(L64:L72,{"*Xerox*Color*","*Color*Xerox*"}))
L75	L75	=COUNTIF(L64:L72,"*Xerox*Color*")+COUNTIF(L64:L72,"*Color*Xerox*")

 

[BobColorado]

Oh, that is very nice to have another way to do this.

THANK YOU!!!