Your summation column is incorrect - there are no values to sum in Column A.

It would make sense to use the headers in your table to define the criteria - in this case it then makes sense to link the headers to the source of the Validation List... ie:

F18: =INDEX($G$6:$G$15,COLUMNS($F18:F18))
copy across to I18

F19: =SUMIF($D:$D,F$18,$B:$B)
copy across to I19