On May 3, 1:30 pm, rob117 wrote:
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

Assume you have your earliest date in D1 and your latest in D2.
=SUMPRODUCT(B2:B366*(A2:A366=-D1)*(A2:A366<=D2))

HTH
Kostis Vezerides