Looking for a formula on averages and I am stumped

I am kind of new to this and I know many of you will say this was super easy. So I appreciate the help and the tips

I am trying to make a sandwich bread and meat order sheet for a caterer.

what I need to do is divide cells B3-B10 by Average using B18 as the whole number. With only cell B3 being 2x the other cells. Something like the following. If I change the subtotal everything will change.


Subtotal...............................18

Any help will be appreciated.

Try this.

Note, depending on your number of sandwich types and your subtotal a solution may not exist. When that was the case I had it add the difference to Turkey.

Thank you... This looks like what I want with more details, which is great! Thanks again