How do I set up an ordering sheet based on averages of past sales

[Dexter]

Trying to predict gallons to order based on past gallon sales.

 

[David Biddulph]

Reading what you said in the subject line but omitted from the message body,
if what you want is the average, the relevant Excel function is AVERAGE.