Total Portfolio Value using SumProduct Total Portfolio Inoome using SumProduct 1 In ColumnF, calculate the value of each holding 2 sum the values of all the holdings to find portfolio total value in cell F13 3 calculate the portfolio total value in cell E21 using the "sumproduct" function 4 calculate the \% of the total portfolio that each holding represents in column G 5 calculate the income from each holding in column I 6 sum to total income in cell I13 7 use "sumproduct" in cell E22 to calculate total income 8 Calculate the portfolio weighted average Beta in cell J13 using sumproduct formula