You can use SUMIF() function here. First you write the range of where you search the cell.
Secondly, you write the searched characters some cells have.
Lastly, you write the range of list where the data is for summation.
"*" refers that there are some characters after searched characters.