From the course: Excel: Advanced Formulas and Functions

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Writing 3D formulas

Writing 3D formulas - Microsoft Excel Tutorial

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Writing 3D formulas

“

- [Instructor] 3D 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 them Trip 1, 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 2 tab, same order. Everything starts in sale, B2. Good. Trip 4, and then Trip 5. Right, let's go back to the overview. Now, it is time. No more waiting. 3D formula. I want a total of the number of days equals sum, open parenthesis, go to Trip 1. 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 1, colon, Trip 5. So we've got…

Contents