Forum Discussion
HELP/Getting The Data as we want
An alternative could be SUMPRODUCT like in the attached file. I've entered a few formulas and highlighted the cells with formulas with green color. You can enter the other formulas accordingly.
If you have the most current version of Excel, the FILTER function--in conjunction with AVERAGE--should be able to achieve what you want. Is it possible for you to post a link to your actual spreadsheet (easily accomplished if it's in OneDrive or GoogleDrive).
If you would like to research FILTER and its abilities, here's a link: https://www.youtube.com/watch?v=9I9DtFOVPIg
Thank you for your response,
the file: https://docs.google.com/spreadsheets/d/1HM5syGPVJsUlDKkIbFt20ovlKzrE2zvH/edit?usp=sharing&ouid=102921561347763242665&rtpof=true&sd=true
what i need to do is:
I must calculate every years average values for 4 parts.
first is general yearly average value for temp4.5&8.5 and preci4.5&8.5:
The others are winter and summer average calculations, what do i mean is for winter:
and for summer:
All i wanna do is i want to do this not manually, with just dragging down automatically like this:
waiting for your reply, sir.
