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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row references 1
average function 9
Averaging non consecutive cells excluding zero's 4
How to set cell value to emptry if three other columns are empty too 1
Quick SUMIF() query - criteria relating to cell 2
Calculating Average based on 3 filled cells from left in a row 6
numbering rows, but skipping blanks 13
Excel Add ^ to a row of cells containing letters 3

Back
Top