Use nothing instead of zeros in future weeks, that way they won't be
included
or if they are derived from formulas use =IF(future,"",formula)
--
Regards,
Peo Sjoblom
"lsmft" wrote in message
...
I need a formula for deriving a running average over a period of 52
weeks that will not figure in the zeros for the weeks that have not
arrived. It needs to be a formula that figures only the weeks that have
come to past, as well as, as they come to past. Each week it will change
due to new figures coming for the completed week.
Thank you.
--
lsmft
------------------------------------------------------------------------
lsmft's Profile:
http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=526915