how to skip reference rows for fill function

  • Thread starter Thread starter jmhatch
  • Start date Start date
J

jmhatch

Hi all - I desperately need help.
I have an 8x12 block of cells. This 8x12 block is repeated 24 time
representing 24 hours.
I need to take the average of A1:D1 and place that in a differen
column. Then, in the cell just below that, I need to take the averag
of A10:D10. (Basically, I need to skip down 9 rows and take the averag
of four cells in THAT row). If I try to use the fill function, it wa
just give me averages of A1:D1, A2:D2, A3:D3 etc when i want th
averages of A1:D1, A10:D10, A19:D19 all in the same column .....how d
I SKIP cells while using the fill function?
Does any of that make sense?! THANK YOU!!
Jaime
:confused
 
Jaime,

Use the formula

=AVERAGE(OFFSET($A$1,(ROW(A1)-1)*9,0,1,4))

and copy it down

HTH,
Bernie
MS Excel MVP
 
Back
Top