Excel Trick: Sum a Specific Number of Cells

  • Peter Lynch
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: