Averaging

[gocolonel77]

I have a spreedsheet that figures usages of material for each week during a 4 week period. I also have a cell for each material that figures the average for the four week period.
Problem is each week is at zero until I get to that week becasue all the weeks are linked to carry inventory form one week to the next.
So for instance week 1, I might use 50 widgets, week 2, 25 widgets, but since week 3 and 4 are at "0" my 4 week average will not be accurate until all four weeks are complete.

Any way to know what my average is before all four weeks are complete without having to change the formula each week.

Attached is my summary report.

Thanks in advance.

[daddylonglegs]

In Excel 2010 try using AVERAGEIF function like this in J6

=IFERROR(AVERAGEIF(E6:H6,">0"),"")