Question

Can any one tell me how to fix this error message? (#VALUE!)

	J	K	J	M	N	O
	Var_COV
9	Column 1	0.0368%	0.0071%	0.0039%	0.0081%	-0.0001%
10	Column 2	0.0071%	0.0132%	0.0065%	0.0070%	0.0087%
11	Column 3	0.0039%	0.0065%	0.0108%	0.0036%	0.0065%
12	Column 4	0.0081%	0.0070%	0.0036%	0.0114%	0.0060%
13	Column 5	-0.0001%	0.0087%	0.0065%	0.0060%	0.0171%
					SUM	VAR
22	Portfolio 1	0.3	0.3	0.3	0.9	#VALUE!
23	P2	0.3	0.3	0.3	0.9
24	P3	0.3	0.3	0.3	0.9
25	P4	0.3	0.3	0.3	0.9
26	P5	0.3	0.3	0.3	0.9
27	P6	0.3	0.3	0.3	0.9
Formula	{MMULT(K22:M22,MMULT(K9:O13,TRANSPOSE(K22:M22)))}
	Im sure im doing it right but maybe my Variance/ Covariance matrix might be wrong

Answer 1

Matrix multiplication occurs when we have same columns

In MMULT(K9:O13,TRANSPOSE(K22:M22)) you have K9:O13 having 5 columns but K22:M22 transpose will have 1 column only