Calculate the weight

[yaelcohen]

Hello to you

and thanks for the help

I attached a file and ask:
What should be the formula that can calculate the weight of each value line
out of the total value of each year

Thanks a lot!

 

[Hui]

D3: =C3/SUMIFS($C$3:$C$14,$B$3:$B$14,B3)
copy as required

 

[yaelcohen]

Thanks a lot!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!