Sum Only Whole Words for Word Matrix Based on a Keyword List

Example of Situation
Create Artificial Spaces in Front of Range AND Get WHOLE WORDS ONLY.xlsx

I have a list of phrases that I have broken down into single words and created a word matrix.

What am I trying to achieve?
Sum the intersection of word 1 and word 2.

The problem?
I want to sum WHOLE words only and NOT simple text strings.

Example
I have highlighted the total for the phrase "hipaa training" (21,933) in the attached. When I look at the intersection of "hipaa" AND "training", the total shows 22,389 and not 21,933. The reason for this is because of the phrase "hipaatraining" is being counted in this total. Since the word "training" in the phrase "hipaa training" is not a whole word but instead concatenated, I don't want to include these in the total sum.

My current formula

Please Login or Register  to view this content.

What I somehow need to do is put artificial spaces at the beginning and ending of each phrase in the A:A range. Ex: " "&A:A&" " and also use this same methodology for the cell references for each word in the word matrix... but this is where I'm stuck. I don't know how.

Hi Ron, your solution worked perfectly! I admit, I don't understand how your formula does what it does which shows my lack of ignorance for sumproduct. Thanks again!