I am trying to extract a number and add them in a range of cells if they are attached to a certain letter.
Ex: Cell B1=5C, Cell C1=3C, Cell D1=2B Looking to extract and add all cells with the letter C. In this case my total should be 8. Also, if the Cell only contains a C it should equal 8. If the last part isn't easily easily done, I can always make it 8C.