EXCEL: how to count values ​​by cells containing keyword?

Question

excel

Good afternoon!
Tell me how to calculate the sum of all values ​​in column B, by column A (a list of duplicate values), which contains unique values ​​from column C and display them opposite the corresponding unique value in column D? If there is no keyword from column C in column A, then 0 must be entered in column D.

Answer 1

Use the SUMIF function:
=СУММЕСЛИ(A:A;"*" & C1 & "*";B:B)