Paul:
As is often the case in Excel, there are a couple of different ways to get to where you want to go.
Check out this article here on AbleBits for the explanations and examples of several ways to do what you're trying to do.
-addins-blog/excel-if-cell-contains-count-sum/