Forget that posting.
Completely wrong - must be brain fade<g

--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi

Try
=AVERAGE(IF(AND(A1:A100<"";A1:A100<=TEXT(TODAY(); "yyyymmdd"));B1:B100))

You will need to substitute the Swedish works for Average and Text.

--
Regards

Roger Govier


"ano" wrote in message
...
Hi,
I want a cell to display the average from a column B. Column A shows
dates,
starting 20070419 and ending 20070629, and I want to display the
average from
20070419 till today. and only based on filled cells.

I can solve it by using some extra columns but I would like it as
easy as it
could be done.

Hopefully
ano

(Im using a Swedish version explaining why I might use the wrong
terms)