Matching lists with a function

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?