Forum Discussion

meto343's avatar
meto343
Copper Contributor
Jul 20, 2022
Solved

Obtaining Data with Formula

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

  • 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.

2 Replies

  • 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.

    • meto343's avatar
      meto343
      Copper Contributor
      Thank you so much you are a lifesaver!

Resources