AVERAGE(INDIRECT) Function

Hi I am trying to create a formula in cell C3 in worksheet A that will let me average 7 cells in range D2:J2 in worksheet B (SnowDepthData)and then drag the formula across in worksheet A so cell D3 will contain the average of cells K2:Q2 from worksheet B and E3 will contain average of R2:X2 ad so on.

I have been tying the below formula with not much luck:

=AVERAGE(INDIRECT("SnowDepthData!D2:J2" & COLUMN()*7-6 & ":SnowDepthData!D2:J2" & COLUMN()*7))

Thanks Dez

Could you please post a sample sheet? ( no pics please) - Click Go advanced - Manage attachments to attach a sheet

Hi I have attached a sample worksheet, I want to be able to copy or drag the formula in A1 and B1 and C1 to D1 where it will average cells M33 not I3:L3

So in A1 average A33
in B1 E3:L3
and C1 M33
It's faster to type the formula in C1 than to type the necessary one in B1 and drag it right

Your example is also very different from the explanation you provided in post #1

Average multiple group of 7 cells in same row

Dez said:

Hi I have attached a sample worksheet,

Click to expand...

based on your attached file

(copy formula across)
If you want use helper row then

Thanks Pecoflyer I just thought I 'd attach a simpler explanation in my example but the concept of what I was trying to achieve is the same, I am using a large data set so typing in individually in each cell would be impossible.
Thank you Navic that looks like exactly what I am after hopefully I can transpose it into my worksheets.
Kind Regards
Dez