Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel OFFSET Function Gets Range from Row and Column

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
3,157
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jan 23, 2011

The OFFSET function returns a reference, based on a row and column number.

The OFFSET function can:

-- Find sales amount for selected month
-- Sum the selected month's sales
-- Create a dynamic range based on count
-- Sum the last n month's sales

Watch this video to see how to use the Excel OFFSET function, and combine it with other functions.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (0)

Sign In or Sign Up now to post a comment!
Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more