Conditional sum of multiple columns based on multiple (other) columns

I have a data frame of the form below:

Conditional sum of multiple columns based on multiple (other) columns

I have a data frame of the form below: