Excel "Offset" Function question.

Posted on 2016-08-17
Last Modified: 2016-08-17
I am trying to understand what this is averaging.

=AVERAGE(OFFSET('Active Measurements'!$K6,ROW(B1)*7,0,7,1))
Question by:jlcannon
  • 2

Accepted Solution

Martin Andrews earned 500 total points
ID: 41759932
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])

Author Closing Comment

ID: 41759933
thank you for the explanation.

Expert Comment

by:Martin Andrews
ID: 41759939
No prob!

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
OCT or Config.xml 2 33
Unable to open excel in 2016 is slow 4 21
Excel - list cell contents that are not duplicated 4 30
Excel Formula 4 28
This article will show you how to use shortcut menus in the Access run-time environment.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now