Quote Originally Posted by scott56
... I am also adding up a value that is next to the string based on it being found....

So I don't think I can use the countif function for this....
A SUMIF, SUMPRODUCT or SUMIFS might suffice.

As mentioned above .Find and .FindNext don't work when a UDF is called from a worksheet (neither does .SpecialCells).

A looping UDF might be one approach, but (since you are working on a fixed range), a solution using native Excel would allow the use of a Named Function.