Use SUMPRODUCT to calculate the weighted sum of values with varying adjustment factors in Excel without helper columns.