Forum Discussion
Solved
7 Day Average
Hello, I want to calculate the average of various numbers in a week. When drag and filling the formula, it should skip to the next week and calculate the average of the next 7 numbers. When I try...
=MITTELWERT(INDEX($C$3:$C$23;1+(ZEILE(M1)-ZEILE($M$1))*7):INDEX($C$3:$C$23;7+(ZEILE(M1)-ZEILE($M$1))*7))
=AVERAGE(INDEX($C$3:$C$23,1+(ROW(M1)-ROW($M$1))*7):INDEX($C$3:$C$23,7+(ROW(M1)-ROW($M$1))*7))
This works if i correctly understand what you want to do.
=MITTELWERT(INDEX($C$3:$C$23;1+(ZEILE(M1)-ZEILE($M$1))*7):INDEX($C$3:$C$23;7+(ZEILE(M1)-ZEILE($M$1))*7))
=AVERAGE(INDEX($C$3:$C$23,1+(ROW(M1)-ROW($M$1))*7):INDEX($C$3:$C$23,7+(ROW(M1)-ROW($M$1))*7))
This works if i correctly understand what you want to do.
Thanks a lot it worked!