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.