I don't really know where to post this or if its even possible. So I'm a baker making products for local customers in my area. I calculate the items I need to bake by putting orders into excel to total them up. I'm making set boxes for the first time and I wanted to know if it was possible to have an item like 4th Of July Box, and when I put 1 into the cell it will add the correct number of products per box into the cells. (See picture) I can also attach the actual file if needed.
So when I put the 1 in the 4th of July box cell I want the above cells filled in with the corresponding numbers so I can tally the end of how many pasties are need in total for all the boxes... This is hopefully going to save me from manually adding each item. I do have some customers getting 2-3 boxes so if it could increase as I put 1, 2, 3, etc and the items doubling, tripling etc per the box quantity. I'm not sure if this makes sense. I don't really know enough about excel to know if this is even possible. Thank you for any input on this. I've been trying to figure it out for weeks. Thanks in advance!
Attachment 784883
The blue is where I'd like to put the box input and the red is where I'd like for the output quantity per product to be above in the red circle.
I don't really need it done for me I just need to know what this type of function is classified as so I can further research it. Thank you!
Bookmarks