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

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

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

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.
--
David Biddulph

"Dexter" wrote in message
...
Trying to predict gallons to order based on past gallon sales.