Help - Search for set dates then average other cells values
 

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

Help - Search for set dates then average other cells values
 

This worked using US dates (1/1/06 & 12/31/06) so it should work with your
date format, I think.

=(SUMIF(A1:A100,"=1/1/06",B1:B100)-SUMIF _(A1:A100,"=31/12/06",A1:A100))/ _
(COUNTIF(A1:A100,"=A/1/06")- _
(COUNTIF(A1:A100,"31/12/06")))
--
Best wishes,

Jim


"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