Obtaining Data with Formula

Copper Contributor

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.

aşağı çekmek.png

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:

2 Replies
best response confirmed by meto343 (Copper Contributor)


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.

Thank you so much you are a lifesaver!