Excel - ModelOff Elasticity with Mack Wilk - Episode 1836

1,960 views · Published 16 December 2013 · 3:14 · Indexed 27 October 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: Using the SUM Function to Sum Numbers from Multiple Sheets | Elasticity & Flexibility in Excel | Mack Wilk.

Welcome back to the MrExcel netcast! I'm Bill Jelen, and I'm excited to have Mack Wilk, a MODELOFF finalist from 2013, back with us today. Last year, Mack shared some valuable insights on elasticity in Excel, and this year, he's back to show us even more functions and tricks.

In this video, Mack demonstrates how to use the SUM function to sum numbers from multiple sheets at once. He uses a simple example of calculating revenues over a 5-year period, with different assumptions in each sheet. By using the SUM function, he is able to easily calculate the total revenue from all sheets and even find the average price.

But here's where it gets interesting. Mack loves elasticity in Excel, so he takes it a step further by adding two new sheets - one called "Start" and one called "End". By hiding all the data in these sheets, he is able to create a completely flexible model. He then uses the SUM function to sum numbers from "Start" to "End", allowing him to easily manipulate the data and see different results. This is a great trick for creating a dynamic and adaptable model in Excel.

As a repeat finalist in the MODELOFF competition, Mack's expertise in Excel is evident. His use of elasticity in this video is just one example of his advanced skills and creativity. So, good luck to Mack and all the other finalists in this year's competition. And for more Excel tips and tricks, be sure to subscribe to our channel and check out our other videos. Thanks for watching!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Mack Wilk introduces his topic
(00:17) Explanation of the SUM function for multiple sheets
(01:07) Introduction to Mack's trick for using elasticity in Excel
(02:23) Mack demonstrates his trick using the Start and End sheets
(03:00) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Average price calculation
Elasticity in Excel
Excel functions
Flexibility in Excel
Mack Wilk
MODELOFF finalist 2013
Repeat finalist
Revenues calculation
Sales channels
Start and End sheets
Summing multiple sheets


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153661/


At the ModelOff Financial Modeling Championships, I captured some live podcasts with the finalists. Mack Wilk from episode 1616 and 1617 is back this year with a cool trick for elasticity in 3D Spearing formulas in Excel.

More from this channel