yes you're right my mistake when i select a new year i selected another options are not existed that's why gives me 0 so i have last thing i would summing dynamically as you see maybe filling data changes after row 9
HTML Code:
.Cells(9, 4).Value = Total
in this case this is not useful if is possible sum after lastrow filling data maybe after 12 or 15 and so on it based filling data