Quote Originally Posted by NBVC View Post
To be safe, I'd use in E8:

=SUMIF($B$2:$B$5,$C8,$C$2:$C$5)

copied down.
Works great! I went ahead and made the drop down menu and it works as well.

Lastly, what if I want to define Food 1 in a separate location. IE: Food 1 may change very often, and I will be dealing with 2000+ variables. I want to be able to define Food 1 in a separate location and still use the modifier. I attached the sheet again with the drop down list, and a text example of what I'm looking to do. Thank you both again!!! Here: end state request.xlsx