I have have these names in rows alternating with numbers. I have a hlookup formula that searches a row and finds the value and adds it up for each row, BUT if there is more than one instance of the word, then it only finds the first and not anymore beyond that. So I am hoping someone with much more knowledge can provide a formula or even VBA for this to work, IF at all possible. In the attached spreadsheet, WBNB and cell O2, does not add up, nor do the rest. Thanks in advance.
Bookmarks