Hello,
Background:
I am working in Excel with two tables.
In one table I have the portfolio weight and industry of different companies in a fund.
In the other table I have the industry of companies. And in another column Im trying to sum the weights of companies for that specific industry.
Function Im using:
=SUMIF(P4:P9;P4=C7;C6:I6)
Where P4:P9 is the list of industries.
P4 is the first industry in the second list.
C7 is industry in the first list.
C6:I6 is the weights of the companies in the portfolio.
Although its not working. How can I improve?
Bookmarks