CODEWITHSUNDEEP
excelexcel-formulaexcel-2016
Feal
Feal

Reputation: 25

Calculate Average given two Values which determine a Range and Map in to another Column

I want to do some calculations, but I dont know how I can implement the idea. Given the example below:

Example-Picture

I have two numeric values (here: 1960 and 1965). Based on these two numeric values, in the column "H" all the years should be marked as a range (i.e. H2:H6). And based on this range, excel should take the value from the column polcon_REV and apply the average-function to it.

Does anyone have an idea how to realize that?

This solution worked for me (MITTELWERTWENNS = GERMAN FOR AVERAGEIF)

=(MITTELWERTWENNS($F:$F;$D:$D;">="&$H$3;$D:$D;"<="&$I$3;$C:$C;J3))

The last criteria checks a meanhwile introduced third criteria for the different countries for which i have to calculate the average.

Upvotes: 0

Views: 131

Answers (1)

mondaymorning
mondaymorning

Reputation: 56

Try AverageIf function

 =AVERAGEIF(H1:H36000,$L$3,J1:J36000)

Let us know how you get on

Upvotes: 1

Related Questions