How to create percentages for a panel data?

Hello everybody

I have a problem and I would be grateful if someone could help me with this:

So, I have in excel this cell: format

ID Year Value Share_over_total
A 2000 1
A 2001 4
A 2002 9
B 2000 5
B 2001 3
B 2002 1
C 2000 7
C 2001 4
C 2002 2
D 2000 8
D 2001 2
D 2002 3


My problem is that I do not know how to get the values "Share_over_total" in automatic; that is, I would like to obtain the percentage of each value of each ID for each year over the sum of all the other values;

For example, the "Share_over_total" of A for the year 2000 is: 1/(1+5+7+8), the "Share_over_total" of D for the year 2002 is: 3/(9+1+2+3).

Does it exists a way to do this in automatic?

Thank you very much!

Kodi

Try this

In D2 ..

=$C2/SUMIF($B$2:$B$13,$B2,$C$2:$C$13)

Copy down

It worked! Thank you!

Thank you for the feedback.

If your question has been answered, could you please mark the thread as SOLVED : "Thread Tools" on tab on first posting.

Sure. Ok, no prob