I am struggling to find a way to sum the numeric part of cells that contain specific strings. Let's say that: cell A1:
pa 23.45, cell A2:
The result of the sum of A1:A3 I would like to be
34 (23.45+10.55), which is the sum of only A1 and A3 because they contain
So, find the cells in a range that contains
pa and sum the numeric part of them.
I don't want to have separate cells for string and numeric part.