Excel - Simple yearly average

[wwj]

Code: Select all

=AVERAGEIFS($C$3:$C$1000,  $A$3:$A$1000,"> " & E3, $A$3:$A$1000,"<" & E3+1)

Column A: Year data
Column C: values to be averaged.

Column E: Target Year