Drag and Fill Problem

Question

Hello,&nbsp;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.&nbsp;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?&nbsp;Thanks in advance,&nbsp;Oskar

detlef_lewin · Answer

oskar14&nbsp;https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576And a million more tutorials.&nbsp;

detlef_lewin · Answer

oskar14&nbsp;Better use this data structure. Then it is a simple pivot table.

sergeibaklan · Answer

oskar14&nbsp;
For such layout

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

oskar14 · Answer

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

oskar14 · Answer

Detlef_Lewin&nbsp;Thanks!

Forum Discussion

Drag and Fill Problem

5 Replies

Resources