Formula without volatile formulation

Is it possible to achieve the formula neededd in the sample spreadsheet (Excel 2007) without using something like =sumproduct? I have a huge spreadsheet and anything volatile will kill the speed. I'm probably missing something really simple...

Thanks for any ideas