Hi,

You don't need to filter, put this in a cell.

=AVERAGE(IF(DAY(A1:A100)=ROW(A1),B1:B100,FALSE))

Array entered with
Ctrl+Shift+Enter
then drag down 31 rows for days 1 - 31

Mike

"notaclue" wrote:

Hi,
I#m looking for a Formula that returns me the Value of a specific day of a
month.
Example:
Colum A Dates Colum B Values. Now I need the Average Value for each day of
the month.
Now I want in a new sheet the folowing:
Average Value of 1st of all Month
Average Value of 2nd of all Month
Average Value of 3rd of all Month
etc.
Sure I need the Formula for each of that, My main Problem how to "Filter"
all the 1st, 2nd etc.

Thanks so long