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

1. ## 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.

2. ## Re: Sum Only Whole Words for Word Matrix Based on a Keyword List

Using your posted workbook...this regular formula, copied across and down, returns the Col_B value where the corresponding Col_A cell contains the Col_D word AND the Row_1 word.
``Please Login or Register  to view this content.``
Is that something you can work with?

3. ## Re: Sum Only Whole Words for Word Matrix Based on a Keyword List

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!

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1