How can I apply multiple conditions with Function Sumif? Have attached a raw file.

Problem.xlsx