Use SUMIF function with the special escape character “~“, to sum cells containing an asterisk “*“. In our example below, let’s see how the formula works.
The SUMIF function is:
range (A5:A9) – The range of cells to be tested against the criteria,
criteria (“*~*”) – The criteria to sum only cells with an asterisk “*”, use with the special escape character “~“,
[sum_range] (B5:B9) – The actual cells to sum against the criteria.