Hi there, how can we shorten this?
=SUM(SUMPRODUCT(A1:W1,A11:W11),SUMPRODUCT(A2:W2,A12:W12),SUMPRODUCT(A3:W3,A13:W13),SUMPRODUCT(A4:W4,A14:W14))
It's summing the sumproduct of 4 paired arrays.. I've tried using MMULT with TRANPOSE, but it doesn't give me the same result...