Help - Search for set dates then average other cells values

R

rob117

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
 
G

Guest

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")))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select date range then find average of values in another cell 3
Assigning values to dates 7
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
match one column with dates to several colums with dates, copy pas 4
countifs Function not giving desired result with date criteria 2
delete rows with dates between 2
Macro to add column and insert date then in blank cells copy fromprevious cell 1
International Date Conversion to Values 2

Top