I am trying to bypass the intermediate steps in the attachment. The array formula in cell Q34 works but the amendments to it by adding areference to the transpose matrix fails. I have checked my syntax. I want to have a single reference to the array P. I want to calculate the result into a 7x1 matrix in S34 that should be the same as Q34