View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default Average Question

Hi

what cells are the delivery costs in?
if they're in C2,E2,G2,I2
then the formula to average the cost would be
=AVERAGE(C2,E2,G2,I2)

Cheers
JulieD

"LS Steakhouse" wrote in message
...
I have created an inventory sheet and am wanting to average the cost of the
4
deliveries, excludung empty if i did not recieve an order that week. I
have
it set up like this del1 amount del2 amount del3 amount del4 amount.
If I
try and use the suggestion that help gives me it gives me all of the cells
as
an average, I dont need what amount i got delivered, just the prices
averaged. Can someone give me a clue? Thanks
FRM