May be this.........
=(COUNTIF(INDIRECT("Sheet1!$D$7:$M$12"),INDIRECT("A7"))*INDIRECT("Sheet1!B7"))+(COUNTIF(INDIRECT("Sheet1!$D$7:$M$12"),INDIRECT("A8"))*INDIRECT("Sheet1!B8"))+(COUNTIF(INDIRECT("Sheet1!$D$7:$M$12"),INDIRECT("A9"))*INDIRECT("Sheet1!B9"))