I have two arrays - A1:A3 and D5:F5. So, one is horizontal and one is vertical. I would like to use the sumproduct function, but the dimensions of the arrays need to be identical. I tried to use the transpose function, but the transpose function only returns the first number of the array. I need the transpose function (within the sumproduct function) to return a transposed array for the sumproduct to work. Oh, I have been using the CSE feature. Any solutions for this???