• 04/28/2017
    Excel Trick: Sum a Specific Number of Cells

    This video explains how the =SUM and =OFFSET functions can be combined to write a formula that will sum a specific number of cells. This is especially useful when you are working with monthly data, and showing quarterly and annual periods in a financial model. The video also explains why using the =SUM formula for this purpose can lead to errors.

    Click on the icon in the lower right-hand corner of the video player to expand the view to full screen.

    The template used in the video is available for download: Download Template

    What you will learn in this video:

    1. Why =SUM() has limitations.
    2. How the =OFFSET() function can be used to return arrays.
    3. How to effectively use =SUM and =OFFSET together.
    4. How to use F9 to audit formulas.
    Learn Excel as Quickly as Possible (link to course):

    Additional Fun Excel Tricks: