Hi,

I'm averaging 52 rows which are week totals. I have a result column for the
average. Problem: If I have only say 30 of the 52 weeks currently to
average, the formula that does my week totals has a zero in the week rows
that haven't happened yet, so my running average is way too low due to the
zeros. Is there a way to include an if condition for the averaging, like
include this row IF the value is greater than zero?

Or, is there some simpler way to solve this? I could of course not include
the totals formulas until that week has data, which would give me blank
cells for unused weeks, but I hate to have to copy and add formulas to each
week as data is entered. Data entry for volunteers is enough <g>.

Thanks!

--Randy Starkey