How to implement the formula not through “corresponds”, but through “contains”?

Question

excel

Hello
Tell me plz, there are two formulas
=SUMIFS(AMO!$H:$H; AMO!$F:$F; "Paid"; AMO!$S:$S; "proizvodstvo117")
and
=COUNTIF(AMO!$F :$F; "Successfully implemented"; AMO!$S:$S; "proizvodstvo117")
They search and add according to the principle If column F corresponds to "Paid" and column S corresponds to "proizvodstvo117"
And I need
it to search in column S does not match, namely Contains (because there are other words there)
Is it possible to do this?

Answer 1

Try this:
=SUMIFS(AMO!$H:$H; AMO!$F:$F; "Paid"; AMO!$S:$S; "*proizvodstvo117*")
and
=COUNTIFS(AMO!$F:$ F; "Successfully Implemented"; AMO!$S:$S; "*proizvodstvo117*")