Dout related to excel formula

Hi how to solve below question in excel. I was asked this question in an interview but could not find any solution to it. The output should be such that it adds all the occurrence of rule1, rule2 respectively with assigned values to it. Need to write the formula.