DAGUET Member Oct 25, 2016 #1 Dear EXCEL expert Users - I am stuck with this combination returning VALUE and I don't know why. Could you help pls? FYI I have checked everything that may cause the formula not working and did not find any flaw. Regards Attachments Copy of Portfolio-Project.xlsx 86.1 KB · Views: 7
Dear EXCEL expert Users - I am stuck with this combination returning VALUE and I don't know why. Could you help pls? FYI I have checked everything that may cause the formula not working and did not find any flaw. Regards
Chihiro Excel Ninja Oct 25, 2016 #2 Try this? =SQRT(MMULT(TRANSPOSE(T4:T8),MMULT(J15:N19,T4:T8))) Confirmed as array. Note that MMULT returns #Value! error when number of columns in Array1 is different from number of rows in Array 2.
Try this? =SQRT(MMULT(TRANSPOSE(T4:T8),MMULT(J15:N19,T4:T8))) Confirmed as array. Note that MMULT returns #Value! error when number of columns in Array1 is different from number of rows in Array 2.
