|I'm glad you are willing to try this on your own.|
First, I'm not quite sure why you don't just use SUMIF to get your totals, but if you want to use a macro, feel free.
If all you want is the concept, it sounds like this is what I might try:
1 - Put the 10 words you need to search for in a list, say A1:A10
2 - Use a For-Next loop to loop through A1:A10 and Find each word in the ranges with the actual data. As each piece of data is found, add the desired cells associated with the data, placing the updated total in a variable. Once all of the instances of that word have been found, the variable would contain the total amount and could be put in a cell or used elsewhere in the code.
Look up the Find Method in VBA help. It shows a great example of using Find to search a range, including how to Find multiple occurrences of the same text, and then how to perform operations on what it found.
Once you've tried something and need more assisatnce, post what you've tried and we'll see if we can offer some tweaks.
Posting Tip: Before posting Data or VBA Code, read this How-To.