Not sure if I've understood this right but assuming your weekly totals are in
C2:C6 then this formula should do what you want.

=SUM(C2:C6)/COUNTA(C2:C6)

Kewa


"kimbafred" wrote:

Each week we recieve money. We would like a formula at the bottom of the
page for each month that automatically update based on the number of
weeks(lines) that are filled in. If only 1 week of money was filled in the
the sum would be Average(Xline/#week that month) i.e. Week 1 50,000 week 2
60,000 Total for two weeks is 110,000. The formula would know that two
weeks are entered and that we want the average of those two weeks.