Running Average or YTD average

[lsmft]

Is there a simple formula for calculating a running average?
I can do accomplish what I want to do but it takes 4 different steps or
functions to get there.
Example of what I would like:
A-1 thru A-52 equal weeks of the year.
We'll say that A-5 represents the 5th week of the year.
Income for these weeks will be entered in it's respective cell as it
comes due.
In the cells that represent the weeks that have not yet come, a "0" is
in them.
I want to be able to have one cell that reflects the year todate
average of income, and not be affected by the zeros.

 

[Pete_UK]

Assume your weekly income values are in B1 to B52, the following
formula will get you the average excluding zero values:

=sum(B1:B52)/COUNTIF(B1:B52,"<>0")

Hope this helps.

Pete

 

[lsmft]

Thank you, that is much more concise than the 4 step process I have been
using.

 

[Pete_UK]

Thanks for feeding back - glad it could be of use to you.

Pete