This is an array formula that must be entered/edited using ctrl+shift+enter

=AVERAGE(IF(F2:F220,F2:F22))

--
Don Guillett
SalesAid Software

"lbeemer" wrote in message
...
I have a running total for several store's sales numbers that they report
daily. I am trying to add a page for the entire company combined and
include
an average sales month-to-date. However when I enter the formula to add
all
stores I get a zero value for the dates that have yet to come. Then when I
ask for the average for the whole company, I get a number that includes
those
zero values. So far I have just been extending my cell range for the
average
equation to include each day as it occurs and not the zeros, but I would
like
to just pull the infomation from my daily reports and do the company total
on
its own. Any way around this?