Hi, I am trying to calculate the variance of a stock portfolio but I receive an #Value error when I have tried to research this online and I have tried two formulas but not working, any help please? formulas I used are: (I tried both but both gave the same error
=MMULT(MMULT(TRANSPOSE(E4:E9),H4:M9),E4:E9)
=MMULT(TRANSPOSE(E4:E9),MMULT(H4:M9,E4:E9))
sample excel file attached
Bookmarks