Sumifs with multiple criteria for multiple names

Hello

I have been stumped on this formula for a week now, basically what i need is on the projections tab, under the 13 watt light bulbs, to be able to pull the amount of bulbs transferred, but on the final part I need it to select the names column C in the footprints tab, and returns a result using only the names from the A column in drop box tab. The reset of the formula works perfectly except for that part, when i try using just sumifs it will only allow you to select one name at a time, but i want it so that I can add or remove names in the drop bax tab columns which will give different results

Thank you