Drag and Fill Problem

[oskar14]

Hello,

I want to calculate the average number of 7 numbers that I tracked for each day of a week. In the next row there should be the average of the next 7 numbers of the next week. And I want this to be drag and fill.

So in this example the first weeks average would display as one, the second week as 2 and so on.

What would the formula for this be?

Thanks in advance, 

Oskar

[#2]

@oskar14 

Better use this data structure. Then it is a simple pivot table.

[#3]

@oskar14 

For such layout

that could be

=IF(LEFT(D2,4)="Week", AVERAGE(OFFSET(E2,0,0,7) ), "" )

[#4]

Thanks a lot but how do I actually create this pivot table for my specific purpose?

[#5]

@oskar14 

https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bf...

And a million more tutorials.

[#6]

@Detlef Lewin Thanks!