But the situation, it still divides by 5 no matter what. If there is say 1 of
the cells with a zero in it then it, then it should divide by4, for instance
if the 5 cells are as follows with amounts. 5.25,5.65,0,5.45,0. with this
formula the average would be3.27 which is incorrect. the average should be
5.45. Thats where I am having the difficulties, any suggestions?
FRM

"Bob Phillips" wrote:

If you average like this

=AVERAGE(B18,D18,F18,H18)

if any are zero, it won't be included in the average.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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