From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,000 courses taught by industry experts.

Writing 3D formulas

Writing 3D formulas

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Writing 3D formulas

“

- [Instructor] 3-D formulas, they can simplify your life, immensely, if everything is set up right, and let's take a look at that. We want to make an overview tab, and that's where we are right now, and we've got these other five tabs. Let's look at 'em. Trip one, we've got gas, that word in B2 and then the amount that was spent on gas in C2, right? Gas, lodging, destination, days. Go to the trip two tab, same order, everything starts in cell B2. Good. Trip four and then trip five. Right, let's go back to the overview. Now it is time. No more waiting. 3-D formula, I want a total of the number of days equals sum open parentheses, go to trip one. I'm going to hold down the shift key and go to five. Okay and I want the number of days. I'm going to select C5, enter. 43 total days. So look at that formula. So we are doing a sum of cell C5, and then we look at trip one colon trip five. So we've got everything…

Contents