Thread: select date range then find average of values in another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rob117 rob117 is offline
external usenet poster
  
Posts: 3
Default select date range then find average of values in another cell
Hi,

I hope someone can help me.


I have a spreadsheet that has Dates in Column A - Eg 01/01/06 to
31/12/06.
Each date has a value next to it in Column B


Can you search for between specific dates and then average the values
in column B that link to the dates in the range?


Many thanks in advance


Rob

Reply With QuoteReply With Quote