How to correctly compose or what formula to use to calculate the amount according to a certain criterion (google docs)?

Question

Google

There is a table, the screen is presented above. How to correctly compose or what formula to use to calculate the amount according to the following criterion: so that the sum of the Amount column is considered in the Expense column, provided that the Operation column has a certain value (in my example, this value is the word minus), i.e. only those numbers in the "Amount" column that have a certain value in the Operations column would add up, in general, so that some numbers add up, while others do not. Tried like this =SUMIFS(E:E, C:C, "minus") and like this =SUMIF(C:C,"minus", E:E), but Error.

Answer 1

This can also be done with the SUMIF command.
You have the wrong syntax in the command. The help details how to do this:
SUMIF(range ; condition ; [range_sum])
Well, or with SUMIFS:
=sumifs(C37:C40;B37:B40;ʺminusʺ) Separate the
parameters with a semicolon ( ; ). Everything is working.