This can't be a difficult one but I'm having a memory blank!
I have several cells in Column A containing text. In Column B the cell contains a value. I wish to return the sum of the total value if Column A contains a specific word. In other words, I need to search Column A for a string, if that is found return the sum of the values in Column B.
Hope someone can advise and prompt my mind back into action!
BT.
Bookmarks