Excel "Offset" Function question.

I am trying to understand what this is averaging.

=AVERAGE(OFFSET('Active Measurements'!$K6,ROW(B1)*7,0,7,1))
jlcannonAsked:
Who is Participating?
 
Martin AndrewsConnect With a Mentor Commented:
It is averaging a cell range 7 rows high and 1 column wide offset from $K6 by X rows down, X being the value of the row number of B1 multiplied by 7.

Offset syntax is:
OFFSET(reference, rows, cols, [height], [width])
1
 
jlcannonAuthor Commented:
thank you for the explanation.
0
 
Martin AndrewsCommented:
No prob!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.