Calculate with values from 1 and 2 rows

[Anonymous]

Hi,

two values before columns needed. In column SU there are default values. Column average will be calculated with 12 values of SU in column average52. In row 1 and 2 there is the average of 12 values from SU. In Row3 i need the value of Row1 and also in Row2. How can I get this value for calculating at Row3

Row1: (100  + 200  + 300 + 400 + 500 + 600 + 700 + 800 + 900 + 1.000 + 1.100 + 1.200) / 12 = 650

Row2: (100  + 200  + 300 + 400 + 500 + 600 + 700 + 800 + 900 + 1.000 + 1.100 + 1.200) / 12 = 650

Row3: Row1 and Row2 for calculation

Row4: Row2 and Row3 for calculation

Regards

Stefan

[jolivares]

Try to post a table with values you want at least 5 rows...  I can't understand what really you want.

[qlikpahadi07]

Please post a simple Output in Excel which make us more clear 

[ashwanin]

Yes, you have to post a sample of data .

[Anonymous]

Excel File is attached

[ashwanin]

HI Stefan, Dont know, What happens here. But i am not able to find any attachment. I know this is the problem with my pc , bz this happens earlier today .

[Anonymous]

Pls look in my question on top.

[Anonymous]

Hi, it's not earlier today.

[Anonymous]

Hi Ashwani,

do you have found the attched excel-file?

Regards
Stefan