Hi all,

Many thanks for your assistance yesterday here -
http://www.excelforum.com/showthread.php?t=553165

I've created a simple average function that extends range as its filled
across columns. The columns relate to months. Where a month has not been
completed yet I would like the range to be stunted until it has -- thus
future months will only use the average based on current month.

E.G.

Data:

May - 2
June - 2
July - 2
August - 0

Resulting average:

June - Average(May:June)
July - Average(May:July)
August - Average(May:July) ---So it stops until August occurs.

Hope this kinda makes sense.

My column headings are dates so i'm hoping an IF function can be used.

Any help appreciated

Cheers


--
DangerMouse
------------------------------------------------------------------------
DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755
View this thread: http://www.excelforum.com/showthread...hreadid=553554