how to skip reference rows for fill function

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
 
B

Bernie Deitrick

Jaime,

Use the formula

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

and copy it down

HTH,
Bernie
MS Excel MVP
 

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

Function for summing or counting cells based on a specified fill color 2
Counting Max Rows with Multiple Criteria to Check 3
I want the autofill/drag function to skip empty cells 1
Variable range defenition 5
Quick SUMIF() query - criteria relating to cell 2
moving rows to another sheet 3
Macro to fill down automatically the number of rows in a spreadsheet 1
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2

Top