searching by date and crunching associated data

I'm making a log that has the date entry on column A and a number of interest in column E. I'm thinking I might want to make this a table. My workbook contains many sheets that will contain the same log layout. What I would like to be able to do is on a separate worksheet select the date range and the specific sheet and get the average of the number in column E in the given dates. As this is a log new entries will be made at the top pushing all other cells down one row.

Hi matthew72128,

i think i understand what your looking to do, i think maby if you use an advanced filter on your date column so that it will only show dates between the range selected and used an average function down the column you want an average from that should work.

i dont think i could explain how to set up an advanced filter without just doing it for you so mayb google is your friend on that.