highest average of 6 continuous values from a row containing much more numbers

Dear all,

I hope one of you can help me with designing a formula which gives me the highest average of 6 continuous values within a row containing approximately 250 values.

Thx

Thanks daddylonglegs for your help!!

I would like to do the same trick with data arranged in a column. I guessed I could use a similar formula set up. Nevertheless I can't really figure it out.

The formula for my previous question became: =(MAX(SUBTOTAL(1,OFFSET(A2,,ROW(INDIRECT("1:257")),1,6))))

The data in the column which a want to analyse in a similar way is arranged from E8 till E265. I came up with the formula: =(MAX(SUBTOTAL(1,OFFSET(E8,,COLUMN(INDIRECT("8:265")),1,6)))) but then he gives the erro #DIV/0! I guess I went wrong with "8:265".

Thx again.

snb thx for your reply!

I don't really understand what you mean with: "check what the arguments of 'offset' mean", if you mean the explanation of excell what OFFSET does; returns a reference to a range that is a given number of rows and columns from a given reference. I checked it but then I still don't really get what I have to do/change in my formula (sorry I am not so known with excel and its terms)

The small change (switching 1 and 6) you did in the formula did not change the out come of my on formula (still #DIV/0!)

So I guess I do something wrong with OFFSET? Can you explain me about the arguments of OFFSET?

Thx

Thx daddylonglegs and snp for helping me out! I think found the right formula now.