Forum Discussion
Help for Excel
I have 8760 datas in one column. My target is to get over every 24 datas an average. But the seconde average (from 25-59 [24 datas]) has to be individual. In the End i have to count 365 generated datas.
I have 8760 datas in one column. My target is to get over every 24 datas an average. But the seconde average (from 25-59 [24 datas]) has to be individual. In the End i have to count 365 generated datas.
You don't seem to realize what I gave you (or your desire still isn't clear).
The formula I gave you in cell D60 will be the averages from 25-59.
The formula I gave you in cell D84 will be the averages from 60-84,
and so forth, all the way down to Cell D8761 with the averages from 8736-8760
You weren't clear the first time as to which 24 cells were to be averaged, how they were to be selected. I was making an assumption that it could be what SergeiBaklan referred to as a "running average" of the most recent 24.
It's clear now that each set of 24 represents an hourly reading of something for one of the 365 days of a year. That wasn't clear before. The formula will work; I'm sure there are other ways to make it more elegant, but without knowing more about your spreadsheet with the raw data--how its arrayed or organized--it's hard to know how to help.
If you have a date as part of the row of data, then the AVERAGEIF function could produce the averages for any given day. Coupled with a table of days of the year, you could readily produce a column with one row per day and a cell that shows the average for the day. You need to give more information to get a more precise answer.