Averaging to-date lists???

  • Thread starter Thread starter pjroethel
  • Start date Start date
P

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
 
Just outsort the 0

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

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