ub aaa()
Dim arr, i&, j&, n&
arr = [a1].CurrentRegion
ReDim Preserve arr(1 To UBound(arr), 1 To UBound(arr, 2) + 1)
For i = 2 To UBound(arr)
For j = 2 To UBound(arr, 2) - 1
n = n + arr(i, j) * arr(1, j)
Next j
arr(i, UBound(arr, 2)) = n
n = 0
Next i
[e1].Resize(UBound(arr)) = Application.Index(arr, , UBound(arr, 2))
End Sub