Obtaining Data with Formula

[meto343]

Hi everyone!

I have the data of 52 different grid points and what I want to do is to take the average of the data of these 52 points between the years 2022-2098 and fill the table.

So, for example, I want to average the annual value of 2022 in each grid, and when I pull down the table, I want the data for all years to come.

Besides, I need to calculate the summer and winter data in this way, for example, for the winter data, I need to take a value consisting of the data of the 1st, 2nd and 12th months and again I need its average with the other 52 grids. For the summer, I need the average of the data of the 6, 7 and 8 months, the table is in the document.

I look forward to your help as soon as possible, thank you.

Link of the document: https://dosya.co/fnzy6ow9b6yj/hg_van.xlsx.html

[#2 · Accepted solution]

@meto343 

See the attached version (I only did 2022-2040).

If you don't have Microsoft 365 or Office 2021, you'll have to confirm the formulas for winter and summer with Ctrl+Shift+Enter.

[#3]

Thank you so much you are a lifesaver!