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.
Link to this comment:
All Comments (0)