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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920