Averaging to-date lists???

[pjroethel]

Hello,

I am trying to average this months list of numbers to-date from the
first of the month until now. Since there are no entries in the future
cells they are returned as zeros. The average function takes the full
month and averages all the numbers in the month, including the zeros
values.

Is it possible to average the numbers to-date, or do I need to change
the future cell values to "no value" IF functions? In either case,
does anyone have an example of the equation?

Thanks,
Paul

 

[Bob Phillips]

Just outsort the 0

=AVERAGE(IF(rng<>0,rng))

which is an array formula, commit with Ctrl-Shift-Enter