Forum Discussion

Brass Contributor

Mar 15, 2021

Solved

Collect average from a range depending on dates

Dear community, I'm trying to find a neat formula to collect an average for all values corresponding to an arbitrary year, I have a column with dates and a column of corresponding values. I have...

excel

Formulas and Functions

SergeiBaklan
Mar 15, 2021
QWeelon

That's like

=AVERAGEIFS(I:I, A:A, ">=" & DATE(...), A:A, "<=" & DATE(...) )

chahine

Iron Contributor

Mar 15, 2021

u can use averageif(range, criteria=year)

QWeelon
Brass Contributor
Mar 15, 2021
Hi Chahine,

I've tried your formula with some success, although I'm struggling a bit with the year criterion. I've managed to insert a lower limit and would like to complete it with an upper limit as well. Se figure below for formulas.

Column A contains dates and Column I contains the values of which i want to average.

Do you have any suggestions on how I can improve my criteria?

I'm using the Swedish input version in Excel, so commas "," are replaced with semicolons ";".
- SergeiBaklan
  Diamond Contributor
  Mar 15, 2021
  QWeelon
  
  That's like
  
  =AVERAGEIFS(I:I, A:A, ">=" & DATE(...), A:A, "<=" & DATE(...) )
  - QWeelon
    Brass Contributor
    Mar 15, 2021
    Works like a charm!
    
    Thank you everyone!