need macro to count the data based on dropdown input

[balu.vasa]

hi all,
i need a macro to count the number of planned leaves taken by a student in a month

my input is as follow

my output should be as follows...

if i select planned from the drop down then in the same sheet at some particular cell the name of the student and the number of leaves he has taken count should cme


thanks in advance

hemanthsaikumar.