Hi UBSmokie,

Does this array formula work for you? You must press CTRL+SHIFT+ENTER after typing it, not just ENTER.

=SUM((B7:B20/$B$23)*(G7:G20))